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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.