Forum Discussion
harshadrokade
4 years agoPost Partisan
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...
- 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 AverageAllClassesDrop that into matrix as well and send results.
harshadrokade
4 years agoPost Partisan
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
4 years agoCommunity Champion
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 AverageAllClassesDrop that into matrix as well and send results.
- bcdobbs4 years agoCommunity Champion
I'm out at the moment but will fire up the demo file when I get back. Something is very odd in terms of what is being displayed. Will be a few hours.
- harshadrokade4 years agoPost Partisan
- harshadrokade4 years agoPost Partisan
bcdobbs Thanks a lot sir for rea time help. No hurry. Reply when you have a moment. Thanks again