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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
rubio3003
Frequent Visitor

Common Filter for table of measures

Good evening everyone!

I need to find a way to optimize one of my processes. I created a line graph with colored quartiles (line in black represents the values for one individual, colors in the background represent quartiles and gives the ability for individuals to compare to others). I had to create a measure for the individual  sintax: calculate(count(value), filter(value = 1), filter (individual_ID=01).

 

I now need to generate this graph for other individuals. Because there are a lot of measures for each individual, I created all those measures under one table to manage them easier. I am trying to find a way to change the Individual_ID faster (right now, I have to change the ID individually in each measure). Is there any way to do it?

Please help! 🙏

Thank you,
Estefania

Capture.PNG

3 REPLIES 3
v-lionel-msft
Community Support
Community Support

Hi @rubio3003 ,

You created measures for each ‘individual ’, like this, right?

calculate(
count(value), 
filter(
table,
[value] = 1  && [individual_ID]=01
)
)

Maybe you can use 'ALLEXCEPT()' to complete classification statistics automatically:

Measure = 
CALCULATE(
    COUNT([value]),
    ALLEXCEPT(
        table,
        table[value], table[individual_ID] 
    )
)

 

Is it what you want ? or you just want to use the [individual_ID] in a slicer?

 

Best regards,
Lionel Chen

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

Hi, 
@v-lionel-msft Thanks for resopnding. I cannot use the slicer because that makes the colored areas, representing quartiles (aggregated data) dissapear. I was thinking to create a report for each individual so I wonder if there is any way to change the individual's ID throuhgout the report without having to change the ID in each measure one at a time.

 

please let me know if this makes sense. 

Best, 
Estefania

Hi @rubio3003 ,

Is not this what you want?

Measure = 
CALCULATE(
    COUNT([value]),
    ALLEXCEPT(
        table,
        table[value], table[individual_ID] 
    )
)


Best regards,
Lionel Chen

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 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.

Top Solution Authors