AvG value remain same irrespective of slicer selection

[Happy2023_05]

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

[Luis98 · Accepted solution]

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]))

[NikhilChenna · Accepted solution]

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!

[Happy2023_05]

• Thank you.It worked

[NikhilChenna]

Hi @Happy2023_05 ,

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

[Luis98 · Accepted solution]

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]))