Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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))
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))
Hi @GilbertQ
Thank you for your assistance. I was able to use the formula and appreciate the result.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |