Hello -
I am analyzing some usage data that is being dimensioned by a variable called Programmer and a variable called Account Number.
I have the following measure created (which renders properly) to determine at the Account Number level what percent of an accounts total usage comes from a selected programmer (selected by a slicer).
% of Total Viewining = DIVIDE(CALCULATE(SUM(ViewershipData[HoursWatched])),CALCULATE(SUM(ViewershipData[HoursWatched]),ALL(ViewershipData[Programmer])),0)
I also have a second measure created (which also renders properly) which takes % of Total Viewing and turns it into a bin at the Account Number level.
% of Total Viewership Bin =
VAR q =
[% of Total Viewining]
RETURN
(IF(q <= .02,"0 - 2%", IF(AND(q>.02,q<.05),"2% - 5%", IF(AND(q>=.05,q<.07),"5% - 7%",IF(AND(q>=.07,q<.1),"7% - 10%",IF(q>=.1,"10%+"))))))
What I want to be able to do is to filter via a slicer the values that are in the % of Total Viewership Bin. I know you cannot create a slicer based on a measure, so I am wondering if I can turn that into a column or some other way to be able to filter by 5%-7% as an example.
Please let me know if you need additional information to help with this.
Matt Hampton
