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 Day Abnormality Value ...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
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]) ) )