Forum Discussion
Comparing between different filters on the same data
Thank you Gilbert, I hope you can find a way :). So far its ok for me
Hi LarBo
I had a look at the PBIX that you sent and I have created a DAX measure that will look at the 2 values in the single slicer and then calculate the difference between them.
What I did was to find the first selection and calculate the quanity.
I then found the second selection and calculated the quanity for this one also.
And then finally I subtracted the two values.
Here is a link to the PBIX: https://1drv.ms/u/s!Apxn-69XhcAmiO9LToMxVVSpPXUTlA
Please let me know if this works as it is something I would like to blog about.
Hi Gilgert, it's really intersant what you did :).
What you did was very interesting, congratulations! You took the highest selection as the first number and the lowest one with the second number. Thank you so much.
However, my users want to have a separate filter for each of the products, because below they will have a detail per customer that bought each item and have everything in one, although it works, it will not be very practical, is it possible to do that?
- Hi there
Thanks for the kind words
As far as I can currently see I cannot think of a way to have separate slicers to filter the data and measures.
I will think about it some more, but off the top of my head I am not sure if it can be done.Thank you Gilbert, I hope you can find a way :). So far its ok for me