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

FBergamaschi's avatar
FBergamaschi
Icon for Super User rankSuper User
9 months ago

The picture you show is only part of a bigger data model and the table names are not the ones you cite, so it is a bit confusing. We need to see the entire data model to see other relationships that might cause the issue.

 

That said, can you share the pbix so I fix the issue? It is impossible other wise to help you

 

If you can, please send it with a private message (and inform me you did answering here)

 

Thanks

 

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