cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
venkatnitt
New Member

Average should remain same when particular set of slicers Selected

We have are requirement where the average value  in the chart should remain same irresepective of when particular Slicer is selected . Eg

 

Slicer on : Division , Region 

 

DivisionRegionValue
USALA100
USASFO200
USAWES300
USAEAS150
MEXPR57
MEXCR100
  Average 151.17

 

 

The Average is All regions is 151.17

 

When i apply filter (slicer ) on Region ,   the Average value should not change . It should remain 151.  

 

DivisionRegionValueAverage
USALA100151.17

 

Used CACULATE -AVERAGE-FILTER-ALLEXCEPT , still it filters when i selected particular region and it average changes .

 

 

But When i apply filter (slicer) on the Division , the Average should Change. 

 

DivisionRegionValueAverage
USALA100750
USASFO200750
USAWES300750
USAEAS150750

 

Is there any way to do this?

 

 

3 REPLIES 3
Super User IV
Super User IV

Re: Average should remain same when particular set of slicers Selected

Make sure your measure is:

 

Measure = CALCULATE(AVERAGE([Value]),ALLEXCEPT([Division]))

---------------------------------------

Not the Power BI thought police...

I have NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Microsoft v-ljerr-msft
Microsoft

Re: Average should remain same when particular set of slicers Selected

Hi @venkatnitt,

 

Could you try the formula below to see if it works in your scenario? Smiley Happy

 

Avg = 
CALCULATE (
    AVERAGE ( Table1[Value] ),
    ALLSELECTED ( Table1[Division] ),
    ALLEXCEPT ( Table1, Table1[Division] )
)

 

Regards

Microsoft v-ljerr-msft
Microsoft

Re: Average should remain same when particular set of slicers Selected

Hi @venkatnitt,

 

Have you tried the solution provided above? Does it work in your scenario? If it works, could you accept it as solution to close this thread?

 

If you still have any question on this issue, feel free to post here. Smiley Happy

 

Regards

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors