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

RishabSajith's avatar
RishabSajith
Frequent Visitor
9 months ago

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.

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

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