Forum Discussion
babyjb1979
Helper I
Helper IDimension 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...
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.
sevenhills
Super User
Super UserIn 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.