Forum Discussion
Problem with calendar table
renmello post a picture of your overall model. I'd bet money you have a bi-directional or many-to-many relationship(s) that isn't necessary nor desirable.
You can still activate inactive relationships in measures inside of CALCULATE:
Measure Name = CALCULATE( SUM(Table[Field]), USERELATIONSHIP(Table1[Date],Date[Date]) )For that measure only it will activate the relationship and force that path, removing ambiguity.
But I'd still like to see a screenshot of your model.Microsoft recommends minimizing use of both Many-to-Many and Bi-Directional Relationships. In other words, unless you are a DAX expert, find another way to remodel your data to conform to a Star Schema and don't use these two features. I avoid them both at all costs.
Microsoft Guidance on Many-To-Many Relationships
Microsoft Guidance on Bi-Directional Relationships
Microsoft Guidance on Importance of Star Schema
Thanks for replying.
Well, the relationship was there, but it was not active.
When i try to activate it tells me that i cant do it because it would create an ambiguity between the calendar table and the projects table that i am using to know the costs by month.
renmello post a picture of your overall model. I'd bet money you have a bi-directional or many-to-many relationship(s) that isn't necessary nor desirable.
You can still activate inactive relationships in measures inside of CALCULATE:
Measure Name =
CALCULATE(
SUM(Table[Field]),
USERELATIONSHIP(Table1[Date],Date[Date])
)For that measure only it will activate the relationship and force that path, removing ambiguity.
But I'd still like to see a screenshot of your model.
Microsoft recommends minimizing use of both Many-to-Many and Bi-Directional Relationships. In other words, unless you are a DAX expert, find another way to remodel your data to conform to a Star Schema and don't use these two features. I avoid them both at all costs.
Microsoft Guidance on Many-To-Many Relationships
Microsoft Guidance on Bi-Directional Relationships
Microsoft Guidance on Importance of Star Schema
After reading what you shared i realized i had one fact table (costs for each task) and two dimension tables (the calendar table and the tasks table) and i was trying to create a relationship between two dimension tables (the calendar table and the tasks table).
What i did was use the dax function related to bring the finnish date and the actual finnish date from the tasks table and i maintained the relationship from the calendar table to the costs table. Here is a print of how it is now.Now i am able to know how many tasks i have to finnish each month and it is working with the costs when in the dashboard. But i am not sure if i found out the right solution.
Anyway, thanks everyone for the reply and thanks edhans for the knowledge shared. I am very new to power bi and data modelling so i appreciate the help 🙂