ifblanks
1 Topic
COUNTA inside CALCULATE inside IFBLANKS inside IF :)
Hi All, I have the following forumla which gives a count of 'Cancelled' demands in an inventory management system. I want to be able to turn it into an IF statement, that if the result is blank, show as a 0. The main reason is to get it to show 0 in a card visual. What I have so far is below. Count of Cancelled = CALCULATE( COUNTA('Demand Satisfaction Report'[Comments]), 'Demand Satisfaction Report'[Comments] IN { "Cancelled" } )Solved650Views0likes1Comment