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.
I've got a Matrix table like below with "Count of EDM Segments" sent and "Count of Donation Value" (which is the response back), how do I bring the "Response rate%" into this Matrix? Which will be Response rate % = "Count of Donation Value"/"Count of EDM Segments"
I've created a "New Measure":
Syria EDM Responses % = (count('Syria Children''s Emergency Appeal'[Donation Value]))/(count('EDM-Syria Children''s Emergency Appeal Aug 2016'[EDM Segments]))
But when i bring this into "Matrix" or "KPI", it says below.
Solved! Go to Solution.
HI IVYHAI
IT SEEMS TO ME THAT YOUR DATA TYPE IS WRONG. YOU NEED TO SELECT DECIMAL NUMBER DATA TYPE TO NAIL THIS ISSUE.
OR YOU HAVE TO USE COUNTA FUNCTION TO WORK WITH TEXT DATA TYPE.
OR YOU HAVE TO USE COUNTA FUNCTION TO WORK WITH TEXT DATA TYPE.
OR YOU HAVE TO USE "COUNTA" FUNCTION TO WORK WITH TEXT DATA TYPE.
HI IVYHAI
IT SEEMS TO ME THAT YOUR DATA TYPE IS WRONG. YOU NEED TO SELECT DECIMAL NUMBER DATA TYPE TO NAIL THIS ISSUE.
MY PLEASURE.
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 |
---|---|
107 | |
97 | |
75 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |