Forum Discussion

SQUILES's avatar
SQUILES
Helper I
7 years ago
Solved

Infinity Result

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
 
 
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    7 years ago

    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

2 Replies

  • v-diye-msft's avatar
    v-diye-msft
    Community Support
    7 years ago

    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