Forum Discussion

Dimitris_Kats's avatar
Dimitris_Kats
Icon for Helper V rankHelper V
2 years ago
Solved

Display total when a quarter is selected

Hello dear members.   I need your help   I have a matrix displaying the products in the rows,  the quarters in the columns and the sales in values.  I have enabled the row and column totals and a...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Dimitris_Kats 

     

    Please try this:

    I create a set of sample:

    Then add a measure:

    MEASURE =
VAR _currentProduct =
    SELECTEDVALUE ( 'Table'[Product] )
RETURN
    IF (
        ISINSCOPE ( 'Table'[Quarter] ),
        SUM ( 'Table'[Values] ),
        CALCULATE (
            SUM ( 'Table'[Values] ),
            FILTER ( ALL ( 'Table' ), 'Table'[Product] = _currentProduct )
        )
    )

    Finally, add a matrix. the result is as follow:

     

     

    Best Regards

    Zhengdong Xu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Dimitris_Kats 

 

Please try this:

I create a set of sample:

Then add a measure:

MEASURE =
VAR _currentProduct =
    SELECTEDVALUE ( 'Table'[Product] )
RETURN
    IF (
        ISINSCOPE ( 'Table'[Quarter] ),
        SUM ( 'Table'[Values] ),
        CALCULATE (
            SUM ( 'Table'[Values] ),
            FILTER ( ALL ( 'Table' ), 'Table'[Product] = _currentProduct )
        )
    )

Finally, add a matrix. the result is as follow:

 

 

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.