Forum Discussion
IF Then Else function applicable?
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.
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))
3 Replies
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))
