Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
v-ljerr-msft
Employee
Employee

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

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

Greg_Deckler
Super User
Super User

Make sure your measure is:

 

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

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.