Forum Discussion

marri's avatar
marri
Frequent Visitor
8 years ago
Solved

Measure displaying blank value

Hi,   I have a measure which displays blank value instead of 0. My problem scenario is like this. Ihave different tables with relations, in which one table acts like fact table and all other tabl...
Need Help
  • parry2k's avatar
    parry2k
    8 years ago

    here is link to another post in which I provided the solution to show "NA" if measure is blank, you can use the approach to show 0.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Try this

     

    =IF(ISBLANK(CALCULATE(COUNT('Item'[ID]), FILTER(STATUS,status[Status Code]="open"))),0,CALCULATE(COUNT('Item'[ID]), FILTER(STATUS,status[Status Code]="open")))

     

    Does this work?

san_jois's avatar
san_jois
Resolver I
8 years ago

Hi,

I think the issue here is that it is not displaying Open count rows..

For that, I suggest you can edit the table view and for Status id column in the table (if it exists), you can choose 'Show items with no data'

 

Sorry, I am not sure how to represent blank as '0' if you want it specifically that way..

 

However, you can easily count the no. of blanks or zeros in table using a SUMX() function

 

Hope this helps

marri's avatar
marri
Frequent Visitor
8 years ago
Hi,
I wanted to display open count as measure. In the table visual open count is represented as count of itemids along with the fields of other dimensions. So, cannot use calculated column for this scenario
  • parry2k's avatar
    parry2k
    Super User
    8 years ago

    here is link to another post in which I provided the solution to show "NA" if measure is blank, you can use the approach to show 0.