I am struggling with setting a measure as a slicer while I cannot use calculated columns or calculated tables. I have a table simply like this:
I have added two measures which give the count and the list of distinct Y for each X:
Distinct Y in each X - Count =
CALCULATE (
DISTINCTCOUNT ( Table1[Y] ),
ALLEXCEPT ( Table1, Table1[X] )
)
and
Distinct Y in each X - List =
CALCULATE (
CONCATENATEX (
DISTINCT ( Table1[Y] ),
Table1[Y],
", "
),
ALLEXCEPT ( Table1, Table1[X] )
)
Now what I need to have is:
- the measure "Distinct Y in each X, Count" as a slicer
- a visual table reacting to the slicer. This visual table contains only W and Z, something like below:
I cannot use calculated columns or calculated tables. Do you know if this is possible with Power BI?
Many thanks