Forum Discussion
Sum and filter
Hi All, I have a question on my data. Where I need to sum up the amount based on the ID’s and filter for that amount greater than or equal to 1,00,000(Threshold). I have tried but I can add at a...
Try like. Both are measures
ID sum = calculate(sum(Table[Value]),allexcept(table,Table[ID]))
Filtered =
calculate(sum(Table[Value]),filter(table,[ID sum]<=100000))
you may have change <= to >=