Forum Discussion

WhaleWatcher222's avatar
1 year ago
Solved

Card visual two options

Hi Experts   Is it possible to have two option in the following DAX  if the Cell is blank then then below, else if the Cell Has TBC then TBC.  Is this possible.   5.2 Blanks = VAR Avalue = AVE...
  • lbendlin's avatar
    1 year ago

    Not sure what your question is.

     

    You can also use COALESCE

    5.2 Blanks = COALESCE(AVERAGE([5.2]),"N/A")