topic Re: AvG value remain same irrespective of slicer selection in DAX Commands and Tips

AvG value remain same irrespective of slicer selection

Happy2023_05 — Thu, 24 Nov 2022 11:52:17 GMT

hi,

need DAX help. I need to find avg values for store which has to remain same irrespective of slicer selection. 3rd column in the below table has same values. can some one pls help on writing DAX to achive this scenario?

store name values

store 1 10

store 2 20

month avg avg slicer selection

Nov-22 15 15 no store sel

Nov-22 10 15 store 1 selected

Nov-22 20 15 store 2 selected

Re: AvG value remain same irrespective of slicer selection

Anonymous — Thu, 24 Nov 2022 12:04:13 GMT

hi Happy2023_05 ,

If i understand well your ask, you want an average value without matter the filter, you can do that then:

CALCULATE ( AVERAGE ([Values]), ALL( Table Name where is the column of slicer selection, [slicer selection]))

Re: AvG value remain same irrespective of slicer selection

NikhilChenna — Thu, 24 Nov 2022 12:08:21 GMT

Hi Happy2023_05 , its simple and i think the below solution will help you.

1. Create a calculated measure -

Avg_revised =
CALCULATE (

AVERAGE (table1[values]),

ALL(table1)
)

Regards,

Nikhil Chenna

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

Re: AvG value remain same irrespective of slicer selection

Happy2023_05 — Fri, 25 Nov 2022 01:43:30 GMT

Thank you.It worked

Re: AvG value remain same irrespective of slicer selection

NikhilChenna — Fri, 25 Nov 2022 04:08:51 GMT

Hi Happy2023_05 ,

Please Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!