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]), 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

Need Help

3 Replies

  • 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