Forum Discussion

Richard_Lemkhar's avatar
Richard_Lemkhar
New Member
3 years ago
Solved

Calculate YES and avoid BLANK in a widget

Hello

 

I am trying to calculate the number of YES in a column using the below formulas

 

Count of ATDUsed for YES =
CALCULATE(COUNTA('Run List'[ATDUsed]), 'Run List'[ATDUsed] IN { "YES" })
 
but when there is no YES the widget is showing BLANK where i wants 0
 
Can you please help
Need Help
  • Amal-RB's avatar
    Amal-RB
    3 years ago

    try the COALESCE function to convert BLANK (empty) values in your measure to 0.

5 Replies

  • Amal-RB's avatar
    Amal-RB
    Regular Visitor
    3 years ago

    try the COALESCE function to convert BLANK (empty) values in your measure to 0.

    • Amal-RB's avatar
      Amal-RB
      Regular Visitor
      3 years ago

      Richard: it would be like this : COALESCE (CALCULATE(COUNTA('Run List'[ATDUsed]), 'Run List'[ATDUsed] = "YES" ),  0)

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

    Richard_Lemkhar this:

     

     

    Count of ATDUsed for YES =
COALESCE (
CALCULATE(COUNTA('Run List'[ATDUsed]), 'Run List'[ATDUsed] IN { "YES" }),
0
)