Forum Discussion
TopN Slicer on Matrix Table
I use the following that works great on Clusreted Column Chart.
X Axis is CountMeasurementValueInjuryCause = IF([InjuryCauseRankByMeasuredValue]<=[SelectedTopNValue],[Count of Total Gross Incurred])
bdehning , remove filter of hour bucket in case you want Rank on Row GT
InjuryCauseRankByMeasuredValue = RANKX(ALL(InjuryCause[Cause Grouping]),calculate([Count of Total Gross Incurred], removefilters(InjuryCause[Hour Bucket])) ,,0)
Same as the creation of subtotal
Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=24270sSorry to waste your time on the question. I just created a SumMeasurementValueInjuryCause measure and used that for values in the other table.
3 Replies
bdehning , remove filter of hour bucket in case you want Rank on Row GT
InjuryCauseRankByMeasuredValue = RANKX(ALL(InjuryCause[Cause Grouping]),calculate([Count of Total Gross Incurred], removefilters(InjuryCause[Hour Bucket])) ,,0)
Same as the creation of subtotal
Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=24270sThanks for the help.
Can a TopN Slicer be made to work on two different tables on the same page that have different measured value? I would like to add a Sum table in addition to my Count table.
Sorry to waste your time on the question. I just created a SumMeasurementValueInjuryCause measure and used that for values in the other table.