ALL function issue

[Anonymous]

Hi,

I have state, category, subcategory and Sales. my table chart as below

category, Sales, SalesContribution

Sal: Calculate(SUM(Query1[Sales]))

SalesContribution=Calculate(Sal,ALL(Query1[category]))

I do have two slicers 1) state 2) subcategory

I have visual level filters category does not contain "other" and category TOP 10.

SalesContribution total is coming correctly for few selection in category slicer, but few other category selection the SalesContribution is not coming correctly. not sure what is the issue with ALL function. This is very simple but I felt some buy with ALL fuction.

Did anyone encountered the sale issue or any help would be great.

Thanks,
Thimma

[v-chuncz-msft]

@Anonymous,

You may check if ALLSELECTED works.

[LivioLanzo]

Hi @Anonymous

can you show a visual example? maybe post an example of your data as well?

[Anonymous]

Hi,

I have attached pbi file, it contains 2 charts which contains same fields. files available at the below location.

https://www.dropbox.com/s/hs8gca7ts1ih2ff/Test%20File.pbix?dl=0

Chart 1: All records

Chart 2: Only Top 10 records.

But Test 1 KPI value should be same in both charts, not sure why its getting changed when I apply Top 10.

This works well for few SubCat selection, but few getting mismatch. Is there any solution for this.

Thanks,
Thimma

[Anonymous]

Did anyone get a chance to look into the issue, surprised with the ALL function behaviour.

Thanks,

Thimma