topic Re: Add an extra condition in DAX Commands and Tips

Add an extra condition

Evanpooley_2 — Fri, 26 Mar 2021 02:17:28 GMT

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

Re: Add an extra condition

NandanHegde — Fri, 26 Mar 2021 08:14:35 GMT

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

Re: Add an extra condition

Anonymous — Fri, 26 Mar 2021 15:32:52 GMT

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.