Suming up only visible values from column X grouped by column Y

[mikeohara]

Hello,

I am trying to create calculated column Sale_Sum that will sum up all values from Sale_Amt column grouped by Client_ID.

My formula is:

Sale_Sum = SUMX(FILTER(Sales;Sales[Client_ID] = EARLIER(Sales[Client_ID]));Sales[Sale_Amt])

However this sums up all values in dataset, while I want to limit it only to visible rows.

This means with filters applied I would like to see Sale_Sum of 100 next to Client_ID = 1.

Dataset:

Dashboard without filters:

Dashboard with filters:

Thanks in advance.

Mike

[mikeohara]

bump

[mikeohara · Accepted solution]

Done, I have used:

Sale_Sum_Group_By_Meas = CALCULATE(SUM(Sales[Sale_Amt]);FILTER(ALLSELECTED(Sales);Sales[Client_ID] = MAX(Sales[Client_ID])))