Forum Discussion

Miguelcrz's avatar
Miguelcrz
Icon for Helper I rankHelper I
6 years ago
Solved

Replace cells measure

Hi!   I need to replace the cells that have "infinity" with another word like "No sales". The table that has infinity is a variation %     Thanks!!
Need Help
  • Pragati11's avatar
    Pragati11
    6 years ago

    HI Miguelcrz ,

     

    Modify your DAX expression to as follows:

    Calc = DIVIDE(sales A, Sales B, 0) - 1

     

    Also Power BI doesn't allow multiple datatypes in a single column. You will have to either have them as ZEROES which the DIVIDE function handles in Power BI.

     

    Thanks,

    Pragati

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
6 years ago

Hi Miguelcrz ,

 

Is this variation % calculated any dax expression or it is coming directly from source data?

 

Thanks,

Pragati

  • Miguelcrz's avatar
    Miguelcrz
    Icon for Helper I rankHelper I
    6 years ago

    Hi! Pragati11  is a dax expression: (sales A/Sales B)-1

    • Pragati11's avatar
      Pragati11
      Icon for Super User rankSuper User
      6 years ago

      HI Miguelcrz ,

       

      Modify your DAX expression to as follows:

      Calc = DIVIDE(sales A, Sales B, 0) - 1

       

      Also Power BI doesn't allow multiple datatypes in a single column. You will have to either have them as ZEROES which the DIVIDE function handles in Power BI.

       

      Thanks,

      Pragati