cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ivyhai
Post Patron
Post Patron

How to bring response rate calculation into "Matrix"

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"

 

Power bi test.PNG

 

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.

Power bi 2.PNG

2 ACCEPTED SOLUTIONS
BhaveshPatel
Community Champion
Community Champion

HI IVYHAI

 

IT SEEMS TO ME THAT YOUR DATA TYPE IS WRONG. YOU NEED TO SELECT DECIMAL NUMBER DATA TYPE TO NAIL THIS ISSUE.

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

View solution in original post

BhaveshPatel
Community Champion
Community Champion

OR YOU HAVE TO USE COUNTA FUNCTION TO WORK WITH TEXT DATA TYPE.

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

View solution in original post

5 REPLIES 5
BhaveshPatel
Community Champion
Community Champion

OR YOU HAVE TO USE COUNTA FUNCTION TO WORK WITH TEXT DATA TYPE.

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

View solution in original post

BhaveshPatel
Community Champion
Community Champion

OR YOU HAVE TO USE "COUNTA" FUNCTION TO WORK WITH TEXT DATA TYPE.

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.
BhaveshPatel
Community Champion
Community Champion

HI IVYHAI

 

IT SEEMS TO ME THAT YOUR DATA TYPE IS WRONG. YOU NEED TO SELECT DECIMAL NUMBER DATA TYPE TO NAIL THIS ISSUE.

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

View solution in original post

@BhaveshPatel it works.  i feel this community is so helpful!   thanks!!

BhaveshPatel
Community Champion
Community Champion

MY PLEASURE. 

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors