Forum Discussion
Summary Columns in Matrix
I have some "total" measure that I am trying to develop a way to add them as columns in my matrix in a specific order. I have been trying various workarounds I have found, but am unable to get the columns as I need them. Below is an example of what I would want the matrix to look like if possible:
Does anyone have any recommendations on a method to acheive this? Thanks!
Hello kbrvy11 ,
you need to do a custom table that matches your layout then you match the values to it.
check this out https://community.fabric.microsoft.com/t5/Power-BI-Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1354591
Hi kbrvy11
Download example PBIX with the data and DAX shown below
Just create Measures for each of your summary totals columns:
Total = SUM(Data[Additional Research Required]) + SUM(Data[Access Review Required]) + SUM(Data[EnhanceMent Not Required]) + SUM(Data[Control Required]) + SUM(Data[Still Under Review])Review Complete = [Total] - SUM(Data[Still Under Review])% Review Complete = DIVIDE([Review Complete], [Total])Format % Review Complete as a % with 2 decimal place
Add the measures to the matrix Values
NOTE: You don't need a matrix for this, it works the same in a Table visual. I've included both in the example file I provided above.
Regards
Phil
I dont' see any hierarchy in your layout. Shouldn't a table with measures for those columns suffice?
5 Replies
Hello kbrvy11 ,
you need to do a custom table that matches your layout then you match the values to it.
check this out https://community.fabric.microsoft.com/t5/Power-BI-Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1354591
Hi kbrvy11
Download example PBIX with the data and DAX shown below
Just create Measures for each of your summary totals columns:
Total = SUM(Data[Additional Research Required]) + SUM(Data[Access Review Required]) + SUM(Data[EnhanceMent Not Required]) + SUM(Data[Control Required]) + SUM(Data[Still Under Review])Review Complete = [Total] - SUM(Data[Still Under Review])% Review Complete = DIVIDE([Review Complete], [Total])Format % Review Complete as a % with 2 decimal place
Add the measures to the matrix Values
NOTE: You don't need a matrix for this, it works the same in a Table visual. I've included both in the example file I provided above.
Regards
Phil
I dont' see any hierarchy in your layout. Shouldn't a table with measures for those columns suffice?
Hi kbrvy11 ,
Just checking in to see if you query is resolved and if any responses were helpful.
Otherwise, feel free to reach out for further assistance.Thank you.
Hi kbrvy11 ,
Just wanted to check if the responses provided were helpful. If further assistance is needed, please reach out.
Thank you.
