Forum Discussion
Multiple Measures in matrix on same level
- Anonymous2 years ago
Greg_Deckler Thanks for your contribution on this thread.
Hi Striker0794 ,
Base on your description, it seems that you want to add the additional measures [QTD],[YTD] and [YIM] with the same level as the value field. And these 3 measures not be divided into the date. Am I right? If yes, you can follow the steps below to get it:
1. Create a calculated column as below to get the attributes base on the date("QTD","YTD","orignal month")
2. Create a measure as below to get the values for different attributes
Measure = VAR _attr = SELECTEDVALUE ( 'Table'[Attribute] ) RETURN CALCULATE ( SUM ( 'Table'[value] ), FILTER ( 'Table', 'Table'[Attribute] = _attr ) )3. Add the new calculated column onto the matrix to replace the original field [Month Wise Date] and put the above measure onto Values option
Best Regards
Striker0794 Not sure I fully understand but maybe switch the measures to rows?
Thanks for your time, But if you see screenshot, QTD and YTD are 2 different measures , They are not related to YYYY- MM as shown in Column Headers. First I want to show month wise data and then QTD and YTD, That should work as per slicer.