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

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

Hi RishabSajith,

Wanted to let you know your relatinship creates a problem. 

When you put a field from deal_user (example: deal_user[deal_id]) in a visual:

  • Power BI filters deal_user
  • That filter cannot travel backward to deals (because the active direction goes only from deals → deal_user, not the reverse)

Can you try to mdify the Deal Value measure as below and let me know.

Deal Value =
CALCULATE(
    SUM('newcrm_prod bixo_deals'[price]),
    CROSSFILTER(
        'newcrm_prod bixo_deal_user'[deal_id],
        'newcrm_prod bixo_deals'[id],
        BOTH)
)

 

Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.

  • RishabSajith's avatar
    RishabSajith
    Frequent Visitor
    9 months ago

    Hello ,

     

    This solution does not seem to work.