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:

 

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

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    6 years ago

    something like this:

     

    var f = selectedvalue(flag)

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

  • 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