Forum Discussion

shill1000's avatar
shill1000
Helper IV
3 years ago

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 ...
Need Help
amitchandak's avatar
amitchandak
Super User
3 years ago

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

 

 

shill1000's avatar
shill1000
Helper IV
3 years ago

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.