Forum Discussion
Solved
Count rows for each ID and aggregate
I have this sample table: Id Date Product Running Total 1 2017-01-01 0 3 2 2018-01-01 0 3 3 2019-01-01 0 3 4 2017-01-01 1 6 5 2020-01-01 1 6 6 2021-01-01 1 ...
ALLSELECTED did the trick.
msuser48 You will need to use ALLEXCEPT instead of ALL. Also, this might be of interest: https://community.powerbi.com/t5/Quick-Measures-Gallery/Better-Running-Total/m-p/2755666#M885
Greg_Deckler
can you elaborate how the allexcept should look like? I tried AllExcept(table,product), which still does not work.
ALLSELECTED did the trick.