Difference between categories based on user´s selecction

[paliman]

Hello everyone.

This is my first post here. I´ve been searching for a while without finding what I need.

I have a sales table for different products and I want to build a dynamic measure to calculate the difference between any two categories based on user's selection. I've made a little simplification of my model in excel for better understanding, please see the screenshot below:

So I want the user to pick any two categories and come with the difference in total sales based on that selection. Ideally with two slicers called "Category 1" and "Category 2", but if it's easier with only one slicer, that'll do fine too

I hope it is clear enough, and any suggestion will be greatly appreciated.

Many thanks in advance

Pablo.

[paliman · Accepted solution]

Hi

Just to tell you that I found the solution here

https://stackoverflow.com/questions/51388963/how-to-get-the-difference-between-the-values-selected-b...

Thanks to all who took the time to read my post and think about it

Pablo