I am struggling with where to apply the correct syntax to get the IF ISBLANK function to work with the below measure. I am using the measure as a card visual in a report and depending on the month selected ( month slicer used on the report page) the card displays blank when there has been no serious incidents in that month, what i need the card to do is to display a 0 in the card for those months.
Ive read other posts and have attempted to apply IF IS Blank but am not having any luck, i don’t think i have the syntax order applied correctly.
Could i get some guidance please
My measure is…
Serious Incidents =