COUNT/COUNTROWS return 0 instead of blank

[afbraga66]

Hello,

I am currently have an issue with count/countrows. When they evaluate and return nothing it shows blank instead of 0.

I have 2 tables, a calendar table and a fact table with 10 rows.

I am trying to calculate the percentage of colum ORIT = "Y".

Lines ORIT2 = 
var _orit = CALCULATE(COUNTROWS(dataVN),dataVN[ORIT]="Y")

return if(ISBLANK(_orit),0,_orit)

The result is this. I don't want those extra lines that mean nothing.

The manufacturing data field comes from the calendar table.

How can I avoid this situation and get the desired result?

The .pbix file is in this link if you want to try - https://we.tl/t-bHGwtdUf5d

Thank you.

André

[vapid128]

CALCULATE(COUNTROWS(dataVN),dataVN[ORIT]="Y") + 0

[joaotinti]

Genius

[admdc01]

This is by far the fastest and cleanest solution so far.

[tamerj1 · Accepted solution]

Hi @afbraga66 
Please try https://www.dropbox.com/t/Fm7RwOsIaqz2Duog

Lines ORIT2 =
IF (
    NOT ISEMPTY ( dataVN ),
    COALESCE ( CALCULATE ( COUNTROWS ( dataVN ), dataVN[ORIT] = "Y" ), 0 )
)

[afbraga66]

HI @tamerj1 , It works thank you so much! Still, I'm intrigued on what is the role of ISEMPTY() and why without it, it doesn't work. Could you explain, please? Thank you.

[tamerj1]

@afbraga66 

If the table itself is empty in the current  filter context then you need to keep the result blank. You need to have it zero if only the filtered table by CALCULATE is blank. Just pay attention to the difference between the original table and the filtered table.