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.
- amitchandak
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!
- FBergamaschi
The user table has too many relationships:
Users -> Deals -> Deal User
User -> Deal User
You need only one of these in place at a time, amybe changing it according to your needs
Without the pbix I cannot do more, unfortunately that give you rough suggestions
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
