I have a table like this:
However, I also want to calculate so that it does NOT count when Value column is empty. So in example above it should give total of 2
I know that the below would count everytime VA is va and Value is 3, giving a count of 2, but I am not able to figure out how to do it to exclude when [Value] is empty
Go to Solution.
table1[VA] = "va",
View solution in original post
@az38 Brilliant. Thank you. That did the trick
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.