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 been trying to figure this out but it keeps confusing me more and more.
I have a column called "Payment Status" which has the following items:
I'm trying to show the "Conversion Rate" which equals count of (paid + partial payment + approved + Terminated)
devided by count of (paid + partial payment + pending + Approved + Cancelled + Terminated)
"Remodify" and "Void" should not be included in any of them.
I want to show it as a visual "Guage", for some reason I can't seem to be able to get the function to work.
Solved! Go to Solution.
You can calculated your 2 measures like this:
=
CALCULATE (
COUNTROWS ( DB ),
TREATAS (
{ "Paid", "Partial Payment", "Approved", "Terminated" },
DB[Payment Status]
)
)
=
CALCULATE (
COUNTROWS ( DB ),
TREATAS (
{ "Paid", "Partial Payment", "Pending", "Terminated", "Cancelled" },
DB[Payment Status]
)
)
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
You can do it using CALCULATE but we are going to need to see a bit more data in order to provide the exact measure. @SedoSan
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
What kind of data?
I have a table called DB, inside it this column called "Payment Status"
You can calculated your 2 measures like this:
=
CALCULATE (
COUNTROWS ( DB ),
TREATAS (
{ "Paid", "Partial Payment", "Approved", "Terminated" },
DB[Payment Status]
)
)
=
CALCULATE (
COUNTROWS ( DB ),
TREATAS (
{ "Paid", "Partial Payment", "Pending", "Terminated", "Cancelled" },
DB[Payment Status]
)
)
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Instead of creating 2 measures I just divided the top over the bottom one.
it worked, didn't know about "TREATAS" function.
Thanks!
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 |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |