Forum Discussion

harshadrokade's avatar
harshadrokade
Post 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
Post Partisan
4 years ago

bcdobbs Thanks sir. The card is showing 

 

Actually I am trying to add a column which will provide me the difference between average score by class & average of that class. I need a measure for the same.

 

Can you pls help me with the same which will provide me difference bewteen Average score of specific Class  & verage score by Class

bcdobbs's avatar
bcdobbs
Community Champion
4 years ago
Avg Difference = 

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


Try this.

Add a matrix visual with classes on the rows and drop this into the values.

  • harshadrokade's avatar
    harshadrokade
    Post Partisan
    4 years ago

    THanks bcdobbs Sir.

     

    I tried this but it is giving me wrong values as below-

     

     

    The correct difference values after I manually deduct the average of class from average by class is as below.

     

     

     

    • bcdobbs's avatar
      bcdobbs
      Community Champion
      4 years ago

      Can you drop average by class into the visual and also into a card and send screen shot?

       

      (Or better send your pbix file)

      • harshadrokade's avatar
        harshadrokade
        Post Partisan
        4 years ago

        HI bcdobbs 

         

        This is how it looks in table visual & also in card visual. I can't send pbix file as the organisation doesn;t allow uploads.. Thanks in advance.