Forum Discussion

themoosegoose's avatar
themoosegoose
Frequent Visitor
8 years ago

ALLSELECTED doesn't work with FILTERS

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]), ...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
8 years ago

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's avatar
themoosegoose
Frequent Visitor
8 years ago

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's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Hi themoosegoose

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

     

    Best Regards

    Maggie