Forum Discussion

comish4lif's avatar
comish4lif
Helper II
8 years ago

Column reference... cannot be used with a variation 'MonthNo' because it does not have any

I have a measure that was working previously, but is no longer working after a data refresh. The following function:   Requests Completed by Month = COUNTX(FILTER('Production Approval Workflow', 'P...
Need Help
comish4lif's avatar
comish4lif
Helper II
8 years ago

Xi Jin, 

 

Thanks for the response - but the Time Intelligence was selected (it had the checkmark).

 

I unchecked Time Intelligance and a bunch of visualizations and measures that were working then became broken.

 

Any other suggestions?

v-xjiin-msft's avatar
v-xjiin-msft
Solution Sage
8 years ago

Hi comish4lif,

 

One possibility. Have you created any relationships on this table 'Production Approval Workflow'? Relationship can affect date hierarchy. Please verify this.

 

Thanks,
Xi Jin.

  • comish4lif's avatar
    comish4lif
    Helper II
    8 years ago

    Do I have relationships on that table? Only about 9.

     

    What type of relationship should I be looking at as the source of my problem?

     

    • v-xjiin-msft's avatar
      v-xjiin-msft
      Solution Sage
      8 years ago

      Hi comish4lif,

       

      Ok. It's hard to say. Could you please share us your pbix file with OneDrive if possible? So that I can know your actual situation and make some proper tests.

       

      If you can't share us the file. I would suggest you check all the relationships one by one. Start from date columns.

       

      Thanks.
      Xi Jin.