Count Column Error

[Anonymous]

Hi Experts

I cannot see my error here, its a simple DAX formula. 

LocationCount = CALCULATE(COUNTA(Case_Data[Location])) - works fine

When i add the if function to show empty cell as 0 as opposed to blank i get 0 in the matric table???

LocationCount = IF(CALCULATE(COUNTA(Case_Data[Location]))=BLANK(),0,(CALCULATE(COUNTA(Case_Data[Location]))))

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may take a look at the following post.

https://community.powerbi.com/t5/Desktop/How-to-show-zeroes-in-a-matrix-0-is-not-working/td-p/325999