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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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