Suggestion

[Dhrutivyasa-070]

Hello Community,

I have one Tasting Data set and I want to Compare any  two Taster with their Rating.

Ihave total 10 Taster nd Daily tasted around 2000 Lot.

Sample of DataSet is Given Below.

Lot_ID	Taster	Rating
201	x	40
201	y	45
201	z	40
202	x	50
202	y	53
203	x	40
203	y	40
203	z	60

[v-zhangti]

Hi, @Dhrutivyasa-070 

Based on the data you have provided, what kind of output do you expect? Is it possible to show it in a picture?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[grazitti_sapna]

Hi @Dhrutivyasa-070 

You can try using

ComparisonTable = SUMMARIZE('YourTableName', 'YourTableName'[Taster], "AverageRating", AVERAGE('YourTableName'[Rating]))

Thank you 

Hope this will help.