Issues Creating Relationships between original dataset and virtual table

[Neil_Cooper]

Hi Everyone

Hope you are having a great day 🙂

This is a tricky one to explain but in short I have an origional dataset used and to get the calculation I need I have had to create a virtual table based on this data and then used measures based on the virtual table to get to the correct restlt.  This all works fine but sadly the data needs to be dynamic for slicers, visuals etc.

I am having a hard time linking the virtual table to the main data that I need for the slicers, I have a unique reference number, dates etc that I would normally use to link but I am recieving this error message.

If anyone has seen this before and knows of a way around it that would be amazing!

Thanks so much in advance 

Best wishes

Neil

[v-xicai]

Hi  @Neil_Cooper  ,

Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[v-xicai]

Hi @Neil_Cooper ,

Are there some columns which are created using DAX like left formula?  If so, you may try to change it using right formulas.

Year = 'Calendar'[Date].[Year]                           ---> Year = YEAR('Calendar'[Date])



Month=  'Calendar'[Date].[Month]                         ---> Month= MONTH( 'Calendar'[Date])

Or you may try to create the Calendar table using DAX below to replace your original calendar table, and use it in your other formulas.

Calendar = CALENDAR(MIN('Fact Table'[Date]),MAX('Fact Table'[Date]))   

Or

Calendar =CALENDARAUTO()

If i misunderstood,  could you please share some data sample with key fields and relationships among tables in screenshots?  Do mask sensitive data before uploading.

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Neil_Cooper , how you have created date table. Seem like you have used date column in formula and future used that formula in another formula.

Refer : https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/