Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

IF OR function for calculation to remove error that returns

Hi everyone,   I'm attempting to write an if or formula that will calculate the percentage of payment of revenue. Essentially a collection rate. For all that have numbers greater than 0 in both rev...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

Hi,

Try this measure

=coalesce(divide([Insurance Payment Grouping.Insurance Payment],[Insurance Revenue]),0)

I assume that [Insurance Payment Grouping.Insurance Payment] and [Insurance Revenue] are measures. 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Ashish, this is a PowerBI Custom Column calculation. It's giving me the Expression.Error when I try to execute this formula. Any thoughts on how to fix or update for PowerBI?

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    4 years ago

    Hi,

    From the error, i guess it is a Query Editor error.  In the Query Editor, try this

    =try [Insurance Payment Grouping.Insurance Payment]/[Insurance Revenue] else null

    If this does not work, then share the link from where i can download your PBI file.