Common Filter for table of measures

[rubio3003]

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

[v-lionel-msft]

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.

[rubio3003]

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

[v-lionel-msft]

Hi @rubio3003 ,

Is not this what you want?

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

Best regards,
Lionel Chen