Difference between two totals reached with visual filters

Royal_Trudel — Mon, 16 Jan 2023 14:31:44 GMT

Hello, fellow users!

I'd like to request some help with the visuals that I have built. I need the percentage difference between the two total values displayed below (555.555 and 444.444). The image below shows how the dashboard looks and works (edited out the values for company privacy).

We use these two identical visuals to compare the average earnings between a few types of operations we have, like kiosks, mall shops, street shops, and so on.

We also filter between operations that sell coffee or not, and operations that sell the salty variation of our product.

It all works perfectly fine, but when it comes to adding a visual to display the percentage difference between the total values, I can't seem to implement it because all the base values have been filtered by visual filters, not measures or specific columns on the table.

Thanks in advance for any help provided!

Re: Difference between two totals reached with visual filters

tamerj1 — Mon, 16 Jan 2023 15:10:42 GMT

Hi Royal_Trudel

Interested to see if there is a solution for this problem.

topic Difference between two totals reached with visual filters in DAX Commands and Tips

Difference between two totals reached with visual filters

Re: Difference between two totals reached with visual filters