Forum Discussion

SQUILES's avatar
SQUILES
Icon for Helper I rankHelper 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 Wireli...
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