Forum Discussion
Measure or column for conversion rate
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]
)
)
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
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]
)
)Instead of creating 2 measures I just divided the top over the bottom one.
it worked, didn't know about "TREATAS" function.
Thanks!