Wrong number when filter top10

[YunJ]

Hi, 

I have a table,  I only want 10 top media spending products after filtered by these four slicers.

Then, I made a product slicer, also these 10 top products.

Then I made this bar chart, I also want these 10 top products when product slicer = all. Also, the Format1 slicer will not influence this bar chart so that it can be distinguished by Format1 with different color. 

However, the value of current bar chart is not correct, for example, when format1=ZTC, the table Total value is 54313 which is correct, but the bar chart is 0.53M which is definitely not correct.

Any solution to fix this? The pbix is attached: 

https://www.dropbox.com/s/i3e7xe0658n5jn0/Spend.pbix?dl=0

Thanks a lot for your kindly help.

[amitchandak]

@YunJ , Value on your table visual is also nearly .5 M. I do observe a small difference in file. Is because filter or some blank data not sure on that.

[YunJ]

Hi @amitchandak I transfered the bar chart to a new table. and I found for Format1:ZTC, there are only 9 products (a32 not appeared). I think that's the problem. Is there any solution to fix that?

[amitchandak]

@YunJ , In one visual top 10 based on all 4 filters. And Second Visual , it is based on only 2 filters.

Try using Rank. But rank is context-sensitive. So Try sun category Rank. Refer the first link for that

https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale