Forum Discussion

Dhrutivyasa-070's avatar
Dhrutivyasa-070
Icon for Helper I rankHelper I
3 years ago

Suggestion

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_IDTasterRating
201x40
201y45
201z40
202x50
202y53
203x40
203y40
203z60
   

2 Replies

  • grazitti_sapna's avatar
    grazitti_sapna
    Icon for Super User rankSuper User
    3 years ago

    Hi Dhrutivyasa-070 

    You can try using

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

     

    Thank you 

    Hope this will help.

  • v-zhangti's avatar
    v-zhangti
    Icon for Community Support rankCommunity Support
    3 years ago

    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.