Forum Discussion
Dimension table to filter another dimension table
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 |
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.
2 Replies
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-Forum/ba-p/963216
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.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.
