Forum Discussion

tonyclifton's avatar
tonyclifton
Helper III
8 years ago
Solved

Aggregate Sum based on Column

Hello community,   I am doing my first steps with Power BI and now I've gotten to a point where I require some help. In below example I have row values that need to be aggregated based on the Pare...
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    Hi tonyclifton

    measure below

    Combined = IF(SUM(Sheet5[Current])>0,SUM([Current]),0)

    Best Regards

    Maggie

v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi tonyclifton

measure below

Combined = IF(SUM(Sheet5[Current])>0,SUM([Current]),0)

Best Regards

Maggie