I'm aware that this question has been asked many times but I don't want to hijack any topics. The answers given in those topics didn't work for me.
I've created a dashboard and I use 4 seperate cards that counts how many files are in which status; New, Under Investigation, 4-eyes, Closed. Datatype is text. When you filter on month and there aren't any files in tjht particular status then it shows Blank instead of 0.
I've tried new column and a new measure with this DAX-formula and used that new column in the card but it still shows Blank:
New Measure = if(ISBLANK([Blad1[CurrentStatus]]),0,[Blad1[CurrentStatus]])