Need help writing a measure to calculate total sales while ignoring highlight filters from a visual

[Analysis1103]

I have a report with sales of different items, lets call them bike parts (wheels, handles, seats, etc.). I have a measure that will calculate the total sales for all items, and it ignores filters from a bike parts slicer by using the ALL function. I also have a donut chart which shows all the bike parts, to show a comparison of the sales volumn to each item. When I select a part in that donut chart and it is highlighted, my measure that calculates total sales becomes filtered on that part. How can I get the measure to ignore that highlight filter that is being caused by clicking on an item in the donut chart?

[Anonymous]

Hi @Analysis1103,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[lukiz84]

Can you share the measure?