Forum Discussion

jttdp's avatar
jttdp
Frequent Visitor
8 years ago
Solved

Calculate sums filtered to current row value

Dear community,   I have been struggling to create a new calculated column that involves sums filtered to the values of each row.   Below is a small example of my challenge. Each row represents a...
Need Help
  • MarkS's avatar
    MarkS
    8 years ago

    Hi jttdp,

    For a calculated column this should work

    Contributor share of year Total = DIVIDE(
    CALCULATE(SUM(Table1[Amount]),ALL(Table1[Amount]))
    ,CALCULATE(SUM(Table1[Amount]),ALL(Table1[Contributor],Table1[Amount]))
    ,0)

    and format as percentage.

MarkS's avatar
MarkS
Icon for Resolver IV rankResolver IV
8 years ago

Hi jttdp,

For a calculated column this should work

Contributor share of year Total = DIVIDE(
    CALCULATE(SUM(Table1[Amount]),ALL(Table1[Amount]))
    ,CALCULATE(SUM(Table1[Amount]),ALL(Table1[Contributor],Table1[Amount]))
    ,0)

and format as percentage.

  • BraneyBI's avatar
    BraneyBI
    Icon for Kudo Commander rankKudo Commander
    8 years ago

    Actually, MarkS, your calculation will work properly as a measure.