cancel
Showing results for
Did you mean:
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:

 Date Flag Item Group Subgroup Value jan/20 A 0001 GROUP1 SG1 10 jan/20 A 0002 GROUP1 SG1 20 jan/20 B 0001 GROUP1 SG1 15 jan/20 B 0002 GROUP1 SG1 22 feb/20 A 0001 GROUP1 SG1 18 feb/20 B 0002 GROUP1 SG1 13 feb/20 B 0001 GROUP1 SG1 30 mar/20 A 0001 GROUP1 SG1 30 mar/20 A 0002 GROUP1 SG1 21 mar/20 B 0001 GROUP1 SG1 19

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

 Date Flag Item Group Subgroup Value NewValue jan/20 A 0001 GROUP1 SG1 10 80 jan/20 A 0002 GROUP1 SG1 20 80 jan/20 B 0001 GROUP1 SG1 15 80 jan/20 B 0002 GROUP1 SG1 22 80 feb/20 A 0001 GROUP1 SG1 18 80 feb/20 B 0002 GROUP1 SG1 13 80 feb/20 B 0001 GROUP1 SG1 30 80

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

## Re: sum value over slice

something like this:

var f = selectedvalue(flag)

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

Highlighted
Community Champion

## Re: sum value over slice

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

Announcements

#### August 2020 Community Challenge: Can You Solve These?

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

#### Community Blog

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

#### Community Summit Australia – Join Online!

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

Top Solution Authors
Top Kudoed Authors