Forum Discussion

babyjb1979's avatar
babyjb1979
Icon for Helper I rankHelper I
3 years ago
Solved

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 ta...
Need Help
  • sevenhills's avatar
    sevenhills
    3 years ago

    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's avatar
foodd
Icon for Community Champion rankCommunity Champion
3 years ago

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.