Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Sumup Column based on Filter as Calculated Column

Hi Guys, Can someone help to get the formula in a calculated Column. (I derived it in Measure, but i need the same calculation in Calculated Column). Measure Formula: Current Month Total = CALCULATE...
Need Help
Show and Tell
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    hi  Anonymous 

    Do you want show this expected output in power bi calculated table?

    If so, you need to create a new table like below:

    New table = SUMMARIZE(Table1,Table1[Subject],"Month 1",CALCULATE(SUM(Table1[Month1]),FILTER(Table1,Table1[Class]="A")))

    Result:

     

    here is sample pbix file, please try it.

     

    Regards,

    Lin

v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

hi  Anonymous 

Just adjust the formula as below:

CALCULATE( SUM('Table1'[Month 1]), FILTER(ALL(Table1),'Table1'[Class] IN { "A" } ))
 
Regards,
Lin

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

v-lili6-msft  this formula which you provided sums all i guess.., i am not getting the value only for that particular selection. 😞