Add an extra condition

[Evanpooley_2]

Hello,

I am creating a dashboard that shows the total average score for each student

This is done by calculating the total "Score" and dividing it by the amount of "ClassCodes" per "Student or StudentID"

Currently I have a measure that does the total score divided by Classcode but cant figure out how to add "By Student ID"

This is the correct result when i apply a visual level filter to my current measure

This is my current measure

Score divided by Count of classcode =

DIVIDE(

    SUM('SB_STAGING_ASSESSMENT_RESULTS_UNIQUE'[Score]),

    DISTINCTCOUNT('SB_STAGING_ASSESSMENT_RESULTS_UNIQUE'[classcode])

)

If possible i would like to add "Student ID" to this as anything i try doesnt filter to the student

Any help is appreciated 

Thanks

 

[Anonymous]

@Evanpooley_2 

If you start creating models according to Best Practices, you won't have such issues. Please read this: Understand star schema and the importance for Power BI - Power BI | Microsoft Docs

AND FOLLOW IT ALWAYS TO THE LETTER if you want to keep your sanity and be able to understand what your DAX is doing. Also, this will make your work understandable to others.

[NandanHegde]

Hey,
Can you please show sample data for your datasets and its relationship.
Also it would be great if you could show the current status value and expected value with some dummy numbers from sample dataset.

That might help us in better understanding the use case