Forum Discussion
Issue With Parameter and Filtering
For a problem with this many moving parts it would be helpful if you could post a small sample power bi file. Thanks.
Thanks for reaching out! I've built a test file with a few dummy records. The relationship between the parameter (named "select a term") and test-enrollment is currently inactive, so opening up the file will start with the measures working but the parameter slicer displaying all terms.
Hi SamForcum ,
In looking at your data model, it doesn’t look like it’s set up in a star schema. That may be why you’re running into problems with your DAX measures. I think you're making things overly complicated as a result. If you haven’t already, I’d encourage you to check out the SQL BI training (https://www.sqlbi.com/training/), which is free and will explain how to convert your data model into the star schema so that your data model works. The one-to-many relationship from dimension tables (student, term codes, major code list) to fact table (enrollment) is critical for filtering to work. You can have repeating rows in your fact table, but you should have unique values in your dimension tables when you create your relationships.
For example, for Student ID 2 who changed their major from Art to Math (if I understand that correctly, or maybe they were a double-major) you would only want one row for that student and create 2 columns, one for incoming major and one for current major, or similarly for 1st major and 2nd major.
