Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Relationship of single calendar table to two tables (excel 2 files)

    Bronze Contributor
    Posted 14 days ago
    Hi,

    I'm trying to achieve count as per below result, but I'm not getting the exact count for Table 2


    See attached for your reference.
    I simply created a Calendar and made a relationship with Date column with table 1 but not able to create one more relation using calendar with table 2.

    Please advise how this can be achieved.

    ------------------------------
    Prem Guru
    ------------------------------

    Attachment(s)

    xlsx
    Book2.xlsx   39 KB 1 version
    xlsx
    Book1.xlsx   13 KB 1 version
    pbix
    Tables.pbix   58 KB 1 version


  • 2.  RE: Relationship of single calendar table to two tables (excel 2 files)

    Gold Contributor
    Posted 13 days ago
      |   view attached
    @Prem Guru, the issue was with your modeling. The counts were incorrect because Table 1 and and table 2 were related and hence attempting a relationship between Table 2 and Calendar will render as an "inactive" relationship. Or even, no relationship as PowerBI will already assume a relationship exists already by virtue of the Table 1 relationship. See image of desired counts.
    See updated relationships resulting in the desired counts.

    PBIX attached.


    ------------------------------
    Shungu Dhlamini
    Power BI Consultant
    shungud@gmail.com
    ------------------------------

    Attachment(s)

    pbix
    Tables.pbix   53 KB 1 version


  • 3.  RE: Relationship of single calendar table to two tables (excel 2 files)

    Bronze Contributor
    Posted 11 days ago
    @Shungu Dhlamini - Prefect! this appear to be working for me for most of the visuals.

    I'd made multiple relationship with the dashboard, but missed the simple one.

    Thank you! once again.​

    ------------------------------
    Prem Guru
    ------------------------------



  • 4.  RE: Relationship of single calendar table to two tables (excel 2 files)

    Gold Contributor
    Posted 10 days ago
    My pleasure @Prem Guru

    ------------------------------
    Shungu Dhlamini
    Power BI Consultant
    shungud@gmail.com
    ------------------------------