The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?