There’s a known limitation when using calculation items in slicers. When a user selects a single calculation item, any unrelated measure on the page — like a title measure or a measure that returns text — ends up showing the result of that calculation item, instead of its intended output.
The usual DAX functions like SELECTEDVALUE or VALUES don't work as expected with calculation groups. Also, excluding unrelated measures by adjusting the calculation items DAX's like using ISSELECTEDMEASURE & IF is not an scalable solution, and it makes the calculation item DAXs much more complex.
One common workaround is to create a separate table with the same metric names and use that for slicers. For this purpose, a relationship is required between this proxy table and the Caclution Group table which is currently unavailable in Power BI. It'd be very useful if this issue was resolved sooner or at least the relationship of the proxy table and the calculation group table would become available.
v-mpramanik
on:
Retrieve Power BI admin activity events beyond 28 ...
on:
PULL DATAFLOW REFRESH SCHEDULE WITH THE REST API
on:
Improve error message when dataset mixes cloud and...
on:
Deployment pipeline rule for data factory pipeline...