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.
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
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