Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

DAX: How to control matrix detail level?

Hi,

 

I have a request for the current Matrix, where I would like to control the aggregation level of individuel parts of the matrix.

 

Currently if I filter down on three levels, the matrix will do this for all groups of data in the matrix, but I only want the matrix to do it for specific parts of the matrix, and only show the first aggregated level in my "Others" group.

 

Example of PBI today and my requested format:

 

Is it possible to achive this in dax?

 

I know this is related to the matrix collapse/expand button idea, but I need a workaround asap:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9207006-matrix-collapse-expand-buttons

 

Currently my solution has been to make 3 seperate matrix, with one for North America / Europe, and then a second and third for "Others" and "Total" where I would hide the measure description. Kinda works but seems like a mess.