Forum Discussion

Uzi2019's avatar
Uzi2019
Community Champion
5 years ago
Solved

Incorrect grand Total

Hi Experts,   I have a measure below but when I put it on Matrix against Name and Category so It gives me incorrect grand total. Row wise showing correct value.   Measure= SUMX( SUMMARIZE(...
Need Help
  • Tahreem24's avatar
    Tahreem24
    5 years ago

    Hi Uzi2019 ,
    Try to replace MAX with SELECTEDVALUE so that It will behave according to  your slicer value.

    Measure=
    SUMX(
    SUMMARIZE('Table A',
    'Table A'[Category]
    ),
    IF([Measure 1] <> BLANK(),[Measure 1],
    IF( SELECTEDVALUE('Table B'[Name]) IN {"A","A1","A2"},
    [Cost Measure],
    [Cost Measure 2] * [Actual Measure]
    )
    )
    )

     

Uzi2019's avatar
Uzi2019
Community Champion
5 years ago
I have a slicer for Name which list of values. When I select All values from slicer so only Else part (Cost Measure 2 * Actual Measure) part gets executed.

But I want to show sum of all names means Cost Measure and plus Cost Measure 2 * Actual Measure.
 
Please help me out as I have a report delivery in next one Hour.