Relationships not working

Question

hello community,&nbsp;i need help because i am stuck with a table not responding to my request:&nbsp;i have three colonnes.From the same table but impossible to find what I want :&nbsp;Project NameConsume workload&nbsp;distinct number of Authors&nbsp;only 1 filter from a slicer : date week for a date master table.The problem it's the table show me only one project and there author.&nbsp;I'm from the table view I can see all the infos. I don't understand why not on the report view.&nbsp;thx for your help&nbsp;

beabf · Answer

Anonymous&nbsp;Can you share the pbix file?&nbsp;BBF

anonymous · Answer

Hello BeaBF ,I apologize, but I can't share the data as it is sensitive.However, I can share my formulas with you if that helps.

beabf · Answer

Anonymous&nbsp;Yes, shares formulas and if you can a sample of datas on which you calculate those formulas.In particular, those datas that you should see on visuals but don't return.&nbsp;One question, the date table has a relationship with the fact table?&nbsp;BBF

anonymous · Answer

Context: We faced challenges in correctly filtering data in a specific visual of our Power BI report, particularly in calculating the distinct count of authors by project and week using a date slicer.Formulas UsedConsumed Workload:Consumed Workload =CALCULATE(SUM('Worklogs'[Division]),REMOVEFILTERS('Date Master'[Week]))Purpose: To calculate the sum of divisions from worklogs without being affected by the Date Master week filter.&nbsp;Distinct Authors by Week and Project:Distinct Authors by Week and Project =CALCULATE(DISTINCTCOUNT(Worklogs[AUTHOR_NAME]),TREATAS(VALUES('Date Master'[Week]), Worklogs[Week]),TREATAS(VALUES('Date Master'[Year]), Worklogs[Year]))Purpose: To calculate the distinct count of authors by project and week by applying Date Master filters to Worklogs.&nbsp;Table RelationshipsProjects (PROJECT_ID) to Issues (PROJECT_ID):Type: One-to-ManyActive relationship, essential for linking projects to issues.Issues (ISSUE_ID) to Worklogs (ISSUE_ID):Type: One-to-ManyActive relationship, necessary for connecting issues to worklogs.Date Master (Week) to Worklogs (Week):Type: One-to-ManyActive relationship, enabling filtering of worklogs by week through Date Master.Problems EncounteredFilter Interference: Using the Date Master[Week] slicer for all visuals resulted in incorrect data in the project table because it wasn't directly connected to Worklogs.Complex Relationships: Attempts to enforce relationships and filters through DAX measures did not yield the expected results.Solution ImplementedTo resolve this issue, I decided to use two distinct date slicers:Worklogs[Week] Slicer: Used only for the table displaying project names, Consumed Workload, and Weekly Resources.Date Master[Week] Slicer: Used for all other visuals in the report.Consumed Workload:dax&nbsp;

Forum Discussion

Relationships not working

4 Replies

Related content

Relationship

Relationships

Relationship Issue

Creating relationships

PowerBI Relationships