Forum Discussion
Matrix visual using a measure for total row
Forgive me if this is solved elsewhere but I've searched all over and can't find a solution that matches my requirement. I need to display a matrix of KPI outputs but the total isnt a sum or average of the contents, it's a weighted aggregate. The total row uses a non-standard aggregation.
For example:
Data
Measure Weighting Value Weighted value
M1 0.2 100% 20%
M2 0.6 80% 48%
M3 0.2 90% 18%
Visual
Measure Value
M1 100%
M2 80%
M3 90%
Total 86% (sum of weighted values)
Only solution for now is to use 2 matrix visuals and hide the headers of the second, but that's somewhat impractical if contents, formatting etc. change.
2 Replies
shill1000 , If these are measures, you can use 4 measures including total and can use switch values on row
if these are row values
You can use isinscope and change the total
if(isinscope(Table[Meausre]), [Value measure], [Weighted value measure])
IsInScope - Switch Rank at different levels: https://youtu.be/kh0gezKICEM
Thanks, but I don't think I can get that to work. The values are simply data pulled directly from a table (one value per KPI, per month) and there is no hierarchy. The weighting is simply a calculation applied to each value based upon its row in the data table (KPI). With no hierarchy, every row is in scope. I can't see how I can apply a 'false' hierarchy to achieve this, and in any case, using ISINSCOPE I'd still end up with 2 columns of data; one column has the values but no total, the other has the totals but no value. It wouldn't align and therefore wouldn't scan.
