Forum Discussion
Report Filtering / Aggregation Issue
Hi mmickle23 , hope you are having a great day. You have to work on your model first before anything else. I see many to many relationship between your fact and dim table which is unusual not unless you really understood how it is being used. Otherwise, you can create a dax using userelationship function. DAX Filter - USERELATIONSHIP function
Understanding relationships in Power BI Desktop
Power BI Relationship: Many to Many & Bi-Directional Filtering #Q&A
Data Modeling (Star Schema 🌟) in Power BI – Creating Dimension Tables
Continued ContributorHi mmickle23 , hope you are having a great day. You have to work on your model first before anything else. I see many to many relationship between your fact and dim table which is unusual not unless you really understood how it is being used. Otherwise, you can create a dax using userelationship function. DAX Filter - USERELATIONSHIP function
Understanding relationships in Power BI Desktop
Power BI Relationship: Many to Many & Bi-Directional Filtering #Q&A
Data Modeling (Star Schema 🌟) in Power BI – Creating Dimension Tables