IF Then Else function applicable?

[sclencioco]

Good morning.

Can someone help me on constructin DAX formula for my reporting.

I have (1)Average Ticket Score and (2)Average CSAT Score

I have to compute for the Overall score based on this formula: OV Score = ([Average Score] * 0.8) + ([Average CSAT] * 0.2).

Scenario: If there are no Average CSAT score, it should reflect the Actual Ticket Score value on OVR Score.

Hoping for anyone's assistance. Thank you.

[GilbertQ · Accepted solution]

Hi @sclencioco

You could create a new measure, which will look for a BLANK value, and if BLANK is TRUE then RESULT 1 else RESULT 2

Here is an example you could use below.

New Measure = IF(ISBLANK([Average Score]),[Actual Ticket Score],([Average Score] * 0.8) + ([Average CSAT] * 0.2))

[sclencioco]

Hi @GilbertQ

Thank you for your assistance. I was able to use the formula and appreciate the result.

[GilbertQ]

Hi @sclencioco

Happy to help and solve your issue.