How to get sum by certain row

[Anonymous]

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

Day	Abnormality	Value	Usage Measure
19	Joint	0	7293
19	Joint	86	8869

Current measure result

Day	Abnormality	Value	Usage Measure
19	Joint	86	8869

Expected result

Day	Abnormality	Value	Usage Measure
19	Joint	86	16162

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

Regards,
Nuha

[amitchandak]

@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]) ) )