Forum Discussion
Solved
Calculating a Weighted Performance using DAX
Hello Power BI Community, I am trying to calculate a weighted measure where the result is a single value. This is student assessment data where there are four possible levels that a student m...
Instead of trying to use Distinct() within in the Filter() function, can you try to use it directly inside the Countrows() function like,
COUNTROWS ( DISTINCT ( 'Bmk 2 Retest 4 5 ES'[StudentID] ))
Let me know if this helps.
Oh, and why do you even calculate the value for Beginning if it is gonna be multiplied with zero ? :smileywink:
Instead of trying to use Distinct() within in the Filter() function, can you try to use it directly inside the Countrows() function like,
COUNTROWS ( DISTINCT ( 'Bmk 2 Retest 4 5 ES'[StudentID] ))
Let me know if this helps.
Oh, and why do you even calculate the value for Beginning if it is gonna be multiplied with zero ? :smileywink:
This works great! Thank you.
