Forum Discussion
Summary Columns in Matrix
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?
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