cancel
Showing results for
Did you mean:
Highlighted
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

 Division Region Value USA LA 100 USA SFO 200 USA WES 300 USA EAS 150 MEX PR 57 MEX CR 100 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.

 Division Region Value Average USA LA 100 151.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.

 Division Region Value Average USA LA 100 750 USA SFO 200 750 USA WES 300 750 USA EAS 150 750

Is there any way to do this?

3 REPLIES 3
Super User IV

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

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

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

Putting square pegs in round holes since 1972.

I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Proud to be a Datanaut!

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?

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

Regards

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.

Regards

Announcements

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors