ALLSELECTED doesn't work with FILTERS

[themoosegoose]

How can ALLSELECTED work when I filter a value included in one of the measures required to calculate the percentage?

Number of Visits

# Visits = CALCULATE(SUM(Main[VALUE]),ALL(Main[OrderCode]), FILTER(ALLSELECTED(Main),Main[OrderCode]= 1))

Number of Incomplete Visits

# Visits Incomplete = CALCULATE(SUM(Main[VALUE]), ALL(Main[OrderCode]), FILTER(ALLSELECTED(Main),Main[OrderCode]= 2))

Measure

Measure = IF(MIN(Main[OrderCode]) = 3 , [# Visits Incomplete]/[# Visits], BLANK())

Thank you

[v-juanli-msft]

Hi @themoosegoose

When modifying two measures as below, I can calculate the percentage.

# Visits = CALCULATE(SUM(Main[VALUE]),FILTER(ALL(Main),Main[OrderCode]= 1))

# Visits Incomplete = CALCULATE(SUM(Main[VALUE]), FILTER(ALL(Main),Main[OrderCode]= 2))

Best Regards

Maggie

[themoosegoose]

Using ALL would aggregate the numbers in the roll up level. You can't see that in the sample above, but if you add dates (which is what I have in my real report), you'll be able to see the issue. Is there another option?

[v-juanli-msft]

Hi @themoosegoose

Could you show me some example dataset which will effect the result you want for better analysis?

Best Regards

Maggie