Forum Discussion
Solved
Issue with the DAX with data model in Power BI - Distinct Count
Hello, I have run into the following issue in power BI, im still a beginner using Power BI: I have 3 tables, 1 is deal table which includes all the information about the deal such ( number of be...
, 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!