Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

sum value over slice

Hi community, I need calculate a measure with sum the column "Value" over the date filtered, if the Flag = B. I will use this measure in a table vision. For exemplify, I will use this datas:   ...
mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Please try this measure expression

 

Total B Flags =
CALCULATE (
SUM ( 'Table'[Value] ),
ALLSELECTED ( 'Table' ),
'Table'[Flag] = "B"
)

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat