cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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:

 

DateFlagItemGroupSubgroupValue
jan/20A0001GROUP1SG110
jan/20A0002GROUP1SG120
jan/20B0001GROUP1SG115
jan/20B0002GROUP1SG122
feb/20A0001GROUP1SG118
feb/20B0002GROUP1SG113
feb/20B0001GROUP1SG130
mar/20A0001GROUP1SG130
mar/20A0002GROUP1SG121
mar/20B0001GROUP1SG119

 


If I filter in slice the dates jan/20 and feb/20, I need the result bellow in the table visual:

DateFlagItemGroupSubgroupValueNewValue
jan/20A0001GROUP1SG11080
jan/20A0002GROUP1SG12080
jan/20B0001GROUP1SG11580
jan/20B0002GROUP1SG12280
feb/20A0001GROUP1SG11880
feb/20B0002GROUP1SG11380
feb/20B0001GROUP1SG13080

 

Just explaining, the value is 80 because the lines with flag B in this filtered period has the values: 15 + 22 + 13 + 30. If I filter jan/20 to mar/20 the new value will be 99 and the lines of mar/20 must appear in table.

 

Anyone help me in this case?

Tks!! 🙂

2 REPLIES 2
Highlighted
Community Champion
Community Champion

Re: sum value over slice

something like this:

 

var f = selectedvalue(flag)

return calculate (sum(value),filter(allselected(),f="B"))

Highlighted
Community Champion
Community Champion

Re: sum value over slice

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

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.