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

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.

     

     

     

     

     

    • bcdobbs's avatar
      bcdobbs
      Community Champion
      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. 

      • harshadrokade's avatar
        harshadrokade
        Post Partisan
        4 years ago

        bcdobbs 

         

        I wrongly marked this as resolved but its not.

         

        Now I see below results