Forum Discussion

Striker0794's avatar
Striker0794
New Member
2 years ago
Solved

Multiple Measures in matrix on same level

Hello,   I got stuck into one Business requirment, I want to show Multiple measures on the same level of Matrix as seen in below image. Here Month Wise Data Should Be shown by one measure, and then...
  • Anonymous's avatar
    Anonymous
    2 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