Sum values from visible rows grouping based on another column

[mikeohara]

Hello,

I aim to show sum of values from one column (AMT_COL) grouped on another one (ID_COL) as new column (SUM_COL).

I have created SUM_COL using following formula:

TestCalculation = SUMX(FILTER(Table1;Table1[ID_COL] = EARLIER(Table1[COL_ID]));Table1[AMT_COL])

However it gives me sum of all grouped rows, even those that are currently filtered out (I filter on DATE_COL).

Any tips how to include that visibility aspect to my formula?

Thanks in advance.

Mike

[sokg]

Can ypu provide us sample data???

[mikeohara · Accepted solution]

here you go, more details: https://community.powerbi.com/t5/Desktop/Suming-up-only-visible-values-from-column-X-grouped-by-colu...