Forum Discussion
Solved
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 th...
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))
