topic POWER BI - DAX FORMULA - how do i get the average value for a specific item? in DAX Commands and Tips

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

G_WHO — Tue, 29 Nov 2022 05:10:49 GMT

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.

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

tamerj1 — Tue, 29 Nov 2022 08:47:18 GMT

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

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

rautaniket0077 — Tue, 29 Nov 2022 10:16:35 GMT

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.