Forum Discussion

harshadrokade's avatar
harshadrokade
Icon for Post Partisan rankPost Partisan
4 years ago
Solved

Average calculation

I Have below data. I want to generate a column that will give me difference between below values for each Class- Average score of specific Class ( Like for CLass 1, average of Student A,B,C) Aver...
Need Help
  • bcdobbs's avatar
    bcdobbs
    4 years ago

    That's really odd. 

    can you create a new test measure same as above but without the difference.

     

    Test Measure

VAR AverageAllClasses = 
	CALCULATE (
		[Average by Class],
		REMOVEFILTERS()
	)
		
RETURN AverageAllClasses

      Drop that into matrix as well and send results. 

  • bcdobbs's avatar
    bcdobbs
    4 years ago

    I've updated my demo file with the code I sent and it's working.

     

    Do you want to have a look and see if you can spot what the difference is?

     

    Same link for demo 

harshadrokade's avatar
harshadrokade
Icon for Post Partisan rankPost Partisan
4 years ago

bcdobbs Thanks a lot sir for rea time help. No hurry. Reply when you have a moment. Thanks again

bcdobbs's avatar
bcdobbs
Icon for Community Champion rankCommunity Champion
4 years ago

I've updated my demo file with the code I sent and it's working.

 

Do you want to have a look and see if you can spot what the difference is?

 

Same link for demo