Dimension table to filter another dimension table

[babyjb1979]

Hi all, 

I am creating a star schema structure like this 

Both tables are connected by "Project ID". I hope to use "Division" in Submittal table to filter "Response Time" in Performance table. When I put three "Project ID" together, Looks like Power BI is not happy.

What can I do. Anyone can provide a suggestion?

Thank you in advance.

Branko

Project table

Project ID

A

B

C

Submittal table

Project ID	Division
A	1
A	2
A	3
A	4
A	5
B	2
B	4
B	5
C	1
C	2

Performace table

Project ID
A	3.7
A	7.8
A	4.8
A	7.9
A	6.8
A	4.8
A	7.9
B	8.4
B	8.9
B	9.4
B	9.9
B	10.4
B	10.9
C	11.4
C	11.9
C	12.4
C	12.9
C	13.4
C	13.9

[sevenhills · Accepted solution]

In my view, PBI is getting confused and not knows what exactly you want to see and not able to write DAX and It is by design.

To overcome, I created a measure like CountRows in the Project table and add that measure to your Table visual. The error is gone.

In typical use, we may be using dim values in our visuals and not all three.

[foodd]

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.