Forum Discussion
How to group/classify measures segmentation
I have looked at a couple of options to accomplish what I am looking for but not sure I follow the other solutions. Below is the layout I am looking for in my matrix. All I have is a single transac...
Anonymous
Not very clear with text description, can you provide a sample table and an expected output matrix.
Regards
Paul
I posted a sample set of data. I have calculated measures table that uses this data to calculate Total_Daily_Sales, Total_COGS and Gross Profit. When added to a matrix with Division and Branch as rows and Date as Column everything looks good and calculates correctly for this year, month, Same day last year, previous year ect. The problem is with all the measures they don't cleanly fit on screen.
The layout I shared in the original post would move specific measures into additional rows. I have tried to add these additional rows to a config table but I haven't been able to get other DAX examples to work correctly.