Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hello everyone,
Can someone tell me if and how it is possible to use a measure but only on the already filtered/sliced values.
For example I have a chart that displays the results. I can slice that chart by the version. Than I want the measure to only make calculations based on the sliced values and not on all underlying values. The problem I have is that I want to calculate the max value with reference to an ID but it always calculates the max value of all values.
Lets say I have Testcases which produce results. Some Testcases get tested on diferrent versions. So if I show all results the measure will find the latest one because all data is dispalyed. But If I dont select all versions there is some testcases which have newer results so it wont show as latest result in table. But it should only consider the values that have been sliced.
Solved! Go to Solution.
Sounds like you want to use the ALLSELECTED() filter?
Sounds like you want to use the ALLSELECTED() filter?
User | Count |
---|---|
98 | |
76 | |
74 | |
49 | |
26 |