Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How to get sum by certain row

Morning all,

 

I already try to do below measure to get the result but it was not accurate when it come to 1 single day have more than 1 usage measure.

 

Actual Data

DayAbnormalityValueUsage Measure
19Joint07293
19Joint868869

 


Current measure result

DayAbnormalityValueUsage Measure
19Joint868869

 

Expected result

DayAbnormalityValueUsage Measure
19Joint8616162


Usage measure =
SUMX(
    SUMMARIZE (
        CALCULATETABLE('For Graph',ALL('For Graph'[Abnormality])),
        'For Graph'[Day],
        'For Graph'[UsageMeasure]
    ),
    'For Graph'[UsageMeasure]
)

Regards,
Nuha

General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    Anonymous , I think the below measure should work, unless you have some specific need

    Sum('For Graph'[UsageMeasure])

     

    or

     

    calculate(Sum('For Graph'[UsageMeasure]), filter(allselected(Table), Table[Abnormality] = max(Table[Abnormality]) && Table[Day] = Max(Table[Day]) ) )