Power BI Exchange

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
------------------------------

@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. ​

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

Original Message:
Sent: Jun 17, 2022 10:45 AM
From: Prem Guru
Subject: Relationship of single calendar table to two tables (excel 2 files)

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
------------------------------

@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
------------------------------

Original Message:
Sent: Jun 18, 2022 10:55 AM
From: Shungu Dhlamini
Subject: Relationship of single calendar table to two tables (excel 2 files)

@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

Original Message:
Sent: Jun 17, 2022 10:45 AM
From: Prem Guru
Subject: Relationship of single calendar table to two tables (excel 2 files)

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
------------------------------

My pleasure @Prem Guru​

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

Original Message:
Sent: Jun 20, 2022 06:27 AM
From: Prem Guru
Subject: Relationship of single calendar table to two tables (excel 2 files)

@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

Original Message:
Sent: Jun 18, 2022 10:55 AM
From: Shungu Dhlamini
Subject: Relationship of single calendar table to two tables (excel 2 files)

@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

Original Message:
Sent: Jun 17, 2022 10:45 AM
From: Prem Guru
Subject: Relationship of single calendar table to two tables (excel 2 files)

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
------------------------------