Forum Discussion

Evanpooley_2's avatar
Evanpooley_2
New Member
5 years ago

Add an extra condition

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

 

2 Replies

  • NandanHegde's avatar
    NandanHegde
    Super User
    5 years ago

    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