ALL function is not working

[JPY]

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

[amitchandak]

@JPY , Based on what I got try like

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

[JPY]

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]

@JPY ,

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

[JPY]

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.

[JPY]

Hi @amitchandak ,

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

Thanks!