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

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