Forum Discussion
Post ProdigyTopN Slicer on Matrix Table
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.
Super Userbdehning , 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=24270s
Post ProdigyThanks 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.