Adding a customized column group in table matrix

tomperro — Mon, 17 Jun 2024 18:47:37 GMT

Is there a way to add a customized column group in table matrix similar to the image below?

The counts are all measures.

Re: Adding a customized column group in table matrix

Daniel29195 — Mon, 17 Jun 2024 22:38:39 GMT

tomperro this needs you to create a custom table with the intended structure.

col1 with values : selected 6 months period , selected 6 month period vs previous 6 montth period.

col2 with values : the name of the measures.

then drag and drop them into the matrix in the columns.

create one measure with switch statement :

switch

true() ,

selectedvalue col2 = measure1 , [ measure1] ,

selectedvalue col2 = measure2 , [ measure2] ,

...

let me know if this helps.

Re: Adding a customized column group in table matrix

Anonymous — Tue, 18 Jun 2024 02:39:30 GMT

Hi tomperro ,

Thanks for the reply from Daniel29195 .

Here's the example data I created:

Test Type	Column1	Column2
111	1	18
222	2	17
333	3	16
444	4	15
555	5	14
666	6	13
777	7	12
888	8	11
999	9	10

Create a few simple measures:

A1 = AVERAGE('Table'[Column1]) A2 = COUNT('Table'[Column2]) B1 = SUM('Table'[Column1]) B2 = SUM('Table'[Column2])

Create a table:

Table 2 = CROSSJOIN(VALUES('Table'[Test Type]),{"Group A", "Group B"})

Create two measures that serve to group A1 and B1 into Group A and A2 and B2 into Group B.

Measure = SWITCH( TRUE(), MAX('Table 2'[Value])="Group A",CALCULATE([A1],FILTER('Table','Table'[Test Type]=MAX('Table 2'[Test Type]))), MAX('Table 2'[Value])="Group B",CALCULATE([A2],FILTER('Table','Table'[Test Type]=MAX('Table 2'[Test Type]))) ) Measure 2 = SWITCH( TRUE(), MAX('Table 2'[Value])="Group A",CALCULATE([B1],FILTER('Table','Table'[Test Type]=MAX('Table 2'[Test Type]))), MAX('Table 2'[Value])="Group B",CALCULATE([B2],FILTER('Table','Table'[Test Type]=MAX('Table 2'[Test Type]))) )

Using the matrix visual object for display, the final page visualization is shown below:

If this doesn't help you solve the problem. I would be grateful if you could provide me with the pbix file or sample data.

Remember to remove sensitive data and do not log in to your account in Power BI Desktop when uploading the pbix file.

If you have any other questions please feel free to contact me.

The pbix file is attached.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

topic Re: Adding a customized column group in table matrix in DAX Commands and Tips

Adding a customized column group in table matrix

Re: Adding a customized column group in table matrix

Re: Adding a customized column group in table matrix