Forum Discussion
Domenico96
Helper I
Helper ITotal in Matrix with values on row
Hello, I’m building a custom matrix for a client, and to display the values in rows, I created a custom measure. I couldn’t use the “Switch values to rows” option because it doesn’t export the ...
In one of my screenshots, I'm using a field parameter for the values. I have also attached a pbix in my initial reply, please refer to that. Otherwise, please provide a sanitized (confidential data removed)copy of your own pbix.
cengizhanarslan
Super User
Super UserSince you already have that matix I assuma you have required measues and a parameter to group those measures within different "Distretto"s.
To properly return grand total in your visual I belive you could use the measure below:
KPI Value (with Total) =
VAR IsKpiRow =
ISINSCOPE('KPI Param'[Name])
RETURN
IF(
IsKpiRow,
[KPI Value],
SUMX(
VALUES('KPI Param'[Name]),
[KPI Value]
)
)