topic Group by measure in colum in DAX Commands and Tips

Group by measure in colum

gadielsolis — Thu, 21 Dec 2023 21:24:05 GMT

Hello community.

Im working in a matrix using 3 measures (Measure1, measure2 and measure3) and I'm using the month field from the calendar in columns therefore the matrix will group the 3 measures by month (Month1 - Measure1, Measure2, Measure3||Month2- Measure1, Measure2, Measure3...etc). Is there any way I can group this by measure and show Measure1-Month1, Month2, Month3|| Measure2-Month1, Month2, Month3... etc.

Thank you in advance for the support.

Re: Group by measure in colum

OwenAuger — Fri, 22 Dec 2023 00:20:21 GMT

Hi gadielsolis

I would recommend creating a calculation group to be used for measure selection, along the lines of this article.

https://exceleratorbi.com.au/dynamic-formatting-of-switch-measures/

Then you can create a visual grouped by the calculation item column first, followed by month, with an arbitrary measure (which will be overridden by the calculation items).

Are you able to get that working?