Forum Discussion

afbraga66's avatar
afbraga66
Icon for Helper III rankHelper III
4 years ago
Solved

COUNT/COUNTROWS return 0 instead of blank

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é

0
blank
COUNT
COUNTROWS
replace

6 Replies

  • vapid128's avatar
    vapid128
    Icon for Solution Specialist rankSolution Specialist
    4 years ago
    CALCULATE(COUNTROWS(dataVN),dataVN[ORIT]="Y") + 0
    • afbraga66's avatar
      afbraga66
      Icon for Helper III rankHelper III
      4 years ago

      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's avatar
        tamerj1
        Icon for Community Champion rankCommunity Champion
        4 years ago

        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.