Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How to avoid null values in power bi.

Hi ,

 

I have created below calcualation in tableau.how to replicate this formula into power bi.

 

 

Please help on this issue.

 

Regards,

Venkat

Need Help

1 Reply

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion
    5 years ago

    there are several ways you can do it

    here is one of them

     

    measure =
    CALCULATE ( SUM ( table[measurename] ), table[measurename] > 0 )