Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I have 3 basic tables: Student Details, Student Scores, National/State average scores.
Link to pbix file and excel source here.
I would like to use a slicer to filter to a particular student and see their Scores alongside the State/National for that particular test type. The tests are completed by all students when they are in Year 7 and again in Year 9.
Below is an image with my errors highlighted. The table on the bottom left shows the 'averages' table. The table on the bottom right is roughly what I would like to achieve, but of course with incorrect figures shown.
I am unsure if what I am trying to achieve would be better done with a DAX measure? Below are my best efforts structuring the relationships.
Any help would be appreciated.
Many Thanks, Doug.
Solved! Go to Solution.
Create a colunm in the avarage scores table and the school scores table
Column = 'NAPLAN AVERAGES'[NAPLAN Calendar Year] & 'NAPLAN AVERAGES'[NAPLAN Assessment Area]
Table = FILTER(DISTINCT('NAPLAN AVERAGES'[Column]),'NAPLAN AVERAGES'[Column] <> BLANK())
Proud to be a Super User!
Hey Doug, I am just starting out analysing my schools Naplan data and want to do something. Would it be possible to re share your PBIX file/spreadsheet templates so I can have a look.
Cheers
Damo
Create a colunm in the avarage scores table and the school scores table
Column = 'NAPLAN AVERAGES'[NAPLAN Calendar Year] & 'NAPLAN AVERAGES'[NAPLAN Assessment Area]
Table = FILTER(DISTINCT('NAPLAN AVERAGES'[Column]),'NAPLAN AVERAGES'[Column] <> BLANK())
Proud to be a Super User!
Hi Anthony,
I really appreciate you taking the time to provide a solution.
As a beginner, would you be able to explain how I implement the DAX formulas that you have referenced?
I have tried to follow your directions, but am unsure of where to place the formulas and what to put in the new 'table of unique values'. I assume that I am doing this in the Power Query Editor?
Sorry for this, and thank you!
to Create the new table
click on the data view tab on the Left hand side
click on modeling in the top menu
click new table
and enter the code in the Bar
For the colums
go to the data view tabe
right click on the table on right hand side and select new calculated colunm
Regards,
Anthony
Proud to be a Super User!
This is awesome. Thanks so much. I really appreciate your time helping me out.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |