Infinity Result

[SQUILES]

HI, I calculated the Previous Month Average and then a divide by the number of rows. My DAX look like this: 

Prev_Month_Ave = CALCULATE((AVERAGE('M7 Wireline_Wireless'[DATO_46])/COUNT('M7 Wireline_Wireless'[DATO_46])),PREVIOUSMONTH('M7 Wireline_Wireless'[DATA_PERIODO]))

Then with this value need to calculate every rown in my table:

Umbral = ('M7 Wireline_Wireless'[DATO_46]/'M7 Wireline_Wireless'[Prev_Month_Ave])

Value : 5,665,203
Average: 160986.48
Result: 35.19055141

[v-diye-msft · Accepted solution]

Hi @SQUILES ,

It seems the count of previous month in your data is 0, thus the numerator/0=infinity. Please upload your dummy pbix to Onedrive/sharepoint/dropbix, and share us the link. that would be easier for us to provide the valuable advice.

Best regards,
Dina Ye

[Anonymous]

trying using the divide function instead and see if that helps

https://docs.microsoft.com/en-us/dax/divide-function-dax