Forum Discussion

RodrigoTXRA's avatar
RodrigoTXRA
Icon for Helper I rankHelper I
8 years ago
Solved

Dax formula - dealing with zero amounts

Hi All Hope someone can shed some light on this formula below. Long story short, it works well as long as all the items contains some type of value, as soon as one of the items is ZERO, this formu...
  • Anonymous's avatar
    Anonymous
    8 years ago

    Here it is...

     

    PERFORMANCE WINS =IF( ISBLANK([SUM OF WINS]),0,[SUM OF WINS])/ IF( ISBLANK([SUM OF TARGET WINS]),0,[SUM OF TARGET WINS])  *100

     

    I have replaced the blank by 0, however you can change with your desired value.

     

    Thanks
    Raj

RodrigoTXRA's avatar
RodrigoTXRA
Icon for Helper I rankHelper I
8 years ago

Thanks guys, this helps a lot.

 

Would you be able to assist me inserting an ISBLANK in this formula below?

 

PERFORMANCE WINS = [SUM OF WINS]/[SUM OF TARGET WINS]*100

 

I think that if we manage to insert a ISBLANK on this formula above, then I would be able to get the other formula to work..

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Here it is...

     

    PERFORMANCE WINS =IF( ISBLANK([SUM OF WINS]),0,[SUM OF WINS])/ IF( ISBLANK([SUM OF TARGET WINS]),0,[SUM OF TARGET WINS])  *100

     

    I have replaced the blank by 0, however you can change with your desired value.

     

    Thanks
    Raj

    • RodrigoTXRA's avatar
      RodrigoTXRA
      Icon for Helper I rankHelper I
      8 years ago

      Thanks Raj, I'm new to Power BI and you guys are legends