Replace cells measure

[Miguelcrz]

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!!

[amitchandak]

@Miguelcrz , Power bi does not allow variable data type. In means, you need to make it text ane also take care of data format.

If it coming power bi then use divide function in place of /

If it coming from source, what is the data type of column

[Pragati11]

Hi @Miguelcrz ,

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

Thanks,

Pragati

[Miguelcrz]

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

[Pragati11 · Accepted solution]

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