Difference between categories based on user´s selecction

paliman — Wed, 30 Oct 2019 18:19:19 GMT

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.

Re: Difference between categories based on user´s selecction

paliman — Thu, 31 Oct 2019 15:41:58 GMT

Just to tell you that I found the solution here

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

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

Pablo

topic Re: Difference between categories based on user´s selecction in DAX Commands and Tips

Difference between categories based on user´s selecction

Re: Difference between categories based on user´s selecction