Anyone have a solution for this?
On the below Table, I want to sum column "Qty" by distinct "Case ID" for only the the rows that don't have "BOX ID"
Go to Solution.
Hi @MEDSEN ,
Measure = CALCULATE(SUM('Table'[Qty]),FILTER('Table','Table'[BOX ID]=BLANK()))
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
Hello Jianbo Li,
This is very helpful. Thank you so much for your input.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.