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...
Need Help
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]))

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi amitchandak ,

    No it doesnt work.. I have tried this way before.

    Could you please take a look at the pbix file? I am thinking this issue has to do with other slicers.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi amitchandak ,

      Just want to check with you if you have any idea on how to resolve the issue?

      Thanks!