Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
117 | |
110 | |
109 | |
93 | |
69 |
User | Count |
---|---|
171 | |
135 | |
132 | |
96 | |
94 |