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

anandasim88 — Thu, 27 Apr 2023 12:11:14 GMT

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

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

johnt75 — Thu, 27 Apr 2023 12:41:39 GMT

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

topic Re: How to recalculate measures used in a DAX table made of a union of rows of measures in DAX Commands and Tips

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

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