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
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