Trying to show blanks as zero, but this is ignoring all other filters??

[ansa_naz]

I have the following measure created based on some posts on here:

Job Count = 
var cntrows = countrows(ANSAPBICalls)
return IF(ISBLANK(cntrows),0,(cntrows))

However, when I use this measure in a visual, the visual ignores filters applied to the report page and returns far more than it should, but all with values of zero. Is there any way to get the page filters/slicers to be applied to the measure somehow?

Cheers

[v-chuncz-msft]

@ansa_naz,

You may try using Visual level filters.

[Greg_Deckler]

They should apply but not really enough here to understand what is going wrong. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[ansa_naz]

Thanks for your reply @Greg_Deckler. I have created a sample PBI report, which is available at below link, to display this issue:

https://1drv.ms/f/s!AuiIgc_S9J5JhbNcGD4pMNHen7rDmw

As you can see, if you go to the Reactive Summary page for example:

All the sites to the right of (Blank) are not sites that should be display on this visual, as the filters being applied should have filtered them out. But they are being displayed anyway. Its something to do with how I have written this measure, but unsure how to correct it so it forces filters to be applied, but also to show zero for any items which filter as blank

Cheers

[ansa_naz]

Hopefully someone can help with this?