Forum Discussion

RishabSajith's avatar
RishabSajith
Frequent Visitor
9 months ago
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...
Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    9 months ago

    RishabSajith ,

    , 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