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