Forum Discussion

1001's avatar
1001
Icon for Resolver II rankResolver II
3 years ago
Solved

Managing Blank fields in Calculations

Hi All, I have a column of data where I require an IF statement to SUM the result. This column also contains Blank fields resulting in my display card showing 'BLANK'.  I was wondering using DAX how to first, replace the blank cellls with 0 then run my IF statement. Hoping someone can help. Thanks.

Over Del = if( DFA[Variance W]>=0,DFA[Variance W],0)
 

 

 

 

Need Help
  • 1001's avatar
    1001
    3 years ago

    Situation resolved. 
    As it turns out, PBI has encountered a bug. When I recreate the visual card in a new reprot page, it works fine, just not on the page I'm workong with. I found this previously and had to recreated  my report to a new page as I'll have to do now. So issue is solved. Thanks.

2 Replies

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    3 years ago

    Hi 1001 ,

     

    A card will show blank only if the  result of an aggregation based on the current filter context is indeed blank so if row1 = 1 and row2=blank, row1 + row2 should return 1. What is the formula of the measure in your card?

    • 1001's avatar
      1001
      Icon for Resolver II rankResolver II
      3 years ago

      Situation resolved. 
      As it turns out, PBI has encountered a bug. When I recreate the visual card in a new reprot page, it works fine, just not on the page I'm workong with. I found this previously and had to recreated  my report to a new page as I'll have to do now. So issue is solved. Thanks.