POWER BI - DAX FORMULA - how do i get the average value for a specific item?

[G_WHO]

Say i have a data with the ratings for a particular product 

and I want to find the average rating for just one of those products - what is the DAX formula? I am trying but keep getting error messages. 

[rautaniket0077 · Accepted solution]

Hi @G_WHO ,

you can achieve this by using "AllSelected" Dax.
As you can see in the below image, when i am selecting the product from slicer the 1st table is giving me the average of that product where as the 2nd one is giving me Sales for it.

Dax--

Average of Perticular Product =

    CALCULATE(

        AVERAGE(Orders[Sales]),

        ALLSELECTED(Orders[Product Name])

    )

Please mark my post as Answer if it solves your issue.

[tamerj1]

Hi @G_WHO 
It would perhaps help more if you provide little more details.