Forum Discussion

mahendi's avatar
mahendi
Icon for Helper I rankHelper I
6 years ago
Solved

matrix total for measure

Acc_NoAmountDateName 1 1 Saturday, June 1, 2019 a 1 1 Monday, July 1, 2019 a 1 1 Wednesday, May 1, 2019 a 2 1 Monday, July 1, 2019 b 3 1 Saturday, June 1, 2019 c ...
Need Help
  • nandic's avatar
    nandic
    6 years ago

    mahendi ,

    Here is the formula:

    Measure 4 = IF(HASONEVALUE(Sheet1[Acc_No]),IF(ISBLANK([Measure]),[Measure 2],[Measure]),[Measure]+[Measure 2])

    It checks if row is showing total or not. If it is total then sum these measures.

nandic's avatar
nandic
Icon for Resident Rockstar rankResident Rockstar
6 years ago

mahendi ,

Here is the formula:

Measure 4 = IF(HASONEVALUE(Sheet1[Acc_No]),IF(ISBLANK([Measure]),[Measure 2],[Measure]),[Measure]+[Measure 2])

It checks if row is showing total or not. If it is total then sum these measures.

  • mahendi's avatar
    mahendi
    Icon for Helper I rankHelper I
    6 years ago

    nandic 

    Thank you! I spent 4 days to try and solve this issue.

    This formula solved it for me, was a huge help. 👍