Forum Discussion
Issue with the DAX with data model in Power BI - Distinct Count
, User table should join Either with Deal or Deal/User, not both.
Possible join
User-> Deal -> Deal user.
I can see both deal ID and user ID in deal and deal user, then there should be a composite key and a join be like
user -> deal user -> Deal
Deal user and Deal can many to many and Deal user filter Deal
Hello FBergamaschi ,
Unfortunately I cannot share the whole PBIX with you as it contains sensitive information, however this is the entire data model with the corrected names I mentioned:
Hope this helps.
Super User, User table should join Either with Deal or Deal/User, not both.
Possible join
User-> Deal -> Deal user.
I can see both deal ID and user ID in deal and deal user, then there should be a composite key and a join be like
user -> deal user -> Deal
Deal user and Deal can many to many and Deal user filter Deal
Hello amitchandak ,
Thanks for the help.
This helps to an extend, however I when I add "ref" which is the unique identifier in the deals table, it seems to be pulling all the "ref" which are not a part of the filter as well.
Following is what is there in this Matrix table:
Just tried it again, this seems to work!
Thank you!