Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Measure to calculate only selected values

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.

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

Sounds like you want to use the ALLSELECTED() filter?

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

Sounds like you want to use the ALLSELECTED() filter?

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.