How to recalculate measures used in a DAX table made of a union of rows of measures

[anandasim88]

I have synthesised a DAX table using a UNION of ROWs of different measures. (I used this approach because I wanted to put several rows together of unassociated measures into clean looking table with cell borders.

The latest client request is that we want to use a Slicer. I can use the SELECTEDVALUE of the Slicer and the measures using that formula will recalculate if the user chooses something in the Slicer. This works if the measures are in separate Cards. However, if the measures are used in the DAX table mentioned above, they don't recalculate when the slicer changes.

An example of the UNION table code is

Stats = UNION (
    ROW("Country",CALCULATE(SELECTEDVALUE(DAXCountries[Value]))),
    ROW("Country",CALCULATE([SlicerValue]))
    )

Neither cell formula will react to a change in the Slicer value

Is this possible?

Thanks

Ananda

[johnt75]

No, it isn't. Calculated tables are only calculated on data refresh, so they don't pay any attention to slicers or filters.