Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

ALL function is not working

Hi all,

I am trying to create a measure to ignore the filtering. I used ALL to exclude the country factor as I want to compare each country's numbers against the total (called APJI). 

Measure: APJI = CALCULATE(AVERAGE(ASP[Net Value ASP USD]),ALL(ASP[Country],ASP[District]))

The table in the screenshot looks fine but when I try to select the country filter, the total will start to change.

Anyone knows how to resolve this issue? Here is the sample pbix 

 

Thanks for your time!

Joyce

Need Help

5 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , Based on what I got try like

     

    Measure: APJI = CALCULATE(AVERAGE(ASP[Net Value ASP USD]),ALL())

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi amitchandak ,

      Thanks but I still want the total change according to other filters such as HW/SW.. I only want to ignore the Country in this case. What should I do?

      • amitchandak's avatar
        amitchandak
        Super User
        4 years ago

        Anonymous ,

        Measure: APJI = CALCULATE(AVERAGE(ASP[Net Value ASP USD]),Removefilters(ASP[Country]))