Manage Matrix Collapse summarization - Average instead of SUM

[Power2BI]

Hello Folxs,

I need support to manage the view of the matrix ( Matrix Collapse summarization - Average instead of SUM) in PowerBI as in screenshot below.

1. The matrix missing some infomration from the orginal table, sumrizing the simiar rows, which not needed and need to show all records.

2. Show the avreage for main collapse instead of SUM the Target %! for 3 level of Type, Cat and SubCat. As in screenshot below (Attached the powerbi file Link to PowerBI File 😞

Much apprciated !

Thanks,

AMD

[DataInsights · Accepted solution]

@Power2BI,

It's best practice to create explicit measures instead of using implicit measures. Try creating these explicit measures:

Sum Sales = SUM ( Table3[Sales] )

Sum Target = SUM ( Table3[Target] )

Target Percent = DIVIDE ( [Sum Sales], [Sum Target] )