Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
SedoSan
Frequent Visitor

Measure or column for conversion rate

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:

  • Paid
  • Partial Payment
  • Pending
  • Approved
  • Remodefy
  • Cancelled
  • Terminated
  • Void

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.

1 ACCEPTED 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!  

View solution in original post

4 REPLIES 4
LivioLanzo
Solution Sage
Solution Sage

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!

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.