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
Click here to learn more about the September 2022 updates!
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.
Watch Session 25 of Ted's Dev Camp.