Measure Based on slicer

[TheDogeGuy]

Hello everyone,

I am currently in an internship and I am trying to analyse callcenter agents performance in regard to given discounts. To compare the peformance I use 2 measurements '% of total sales' and '% of discounts given'. After this I divide %discounts given by %ofsales to get a number. 

The sollution I have now works. However currently it takes the total ammount of discounts and the total ammount of sales from the entire table. This is a problem, because certrain product groups always get a discount, so I made a slicer to exclude those. This results in agent giving for example 1% of discounts, however this is 1% of total discounts, while I would like to the % in regards to the total discount based on the slicer. I feel like what I would need to make this work is to make a measure which takes the SUM based on slicer, but I cant find how to do this. 

I think this might be a bit unclear, so I will try to post a screenshot or the PBIX file in a few hours. Need to take away all privacy related information.

[v-kelly-msft]

Hi @TheDogeGuy ,

Is your issue solved?If not,could you pls provide some sample data with expected output?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@TheDogeGuy , You can not have slicer based on the measure. You need to take a binning or segmentation path.

refer to my video on this - https://www.youtube.com/watch?v=CuczXPj0N-k

or refer :

https://www.daxpatterns.com/dynamic-segmentation/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization