Forum Discussion

JustinDoh1's avatar
JustinDoh1
Post Prodigy
2 years ago
Solved

How to display zero using Measure or column value (when there is no value)?

I am trying to display two zero (0) value for a line where it has column data and measure values.   I have this bottom measure which does not display anything because there is no value for [Ave Cen...
Need help with DAX
pr1351's avatar
pr1351
Frequent Visitor
2 years ago

Hi, You might use  COALESCE function to display a specific value (such as zero) when there is no value. so it can be like: CALCULATE(SELECTEDVALUE(COALESCE([YourOriginalMeasure], 0)))

  • JustinDoh1's avatar
    JustinDoh1
    Post Prodigy
    2 years ago

    pr1351 

    Thank you for your feedback.

    I tried with Coalesce. but I am getting this error: "Parameter is not the correct type" when I hover over the red underlined area.

    And also getting this message on the bottom: Column " cannot be found or may not be used in this expression:

    This is original measure:

    The data format of the measure "Skill Mix % All" is Percentage.