Table with IF function totals to zero
Hi there, I'm new to DAX and am probably making a mistake because I'm applying Excel logic! I have employee data, which I used to create a table with headcounts and a measure of % Female: The tricky part is when I want a count of how many countries have % Female >= 30%. I added a measure: Meets Criteria = IF ((Female HC]/ [Total HC]) >= 0.3, 1, 0) It works fine in the table, but the total is 0, when it should be 2. Could someone give me a hand here? Thank you!
