Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
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
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
Make sure your measure is:
Measure = CALCULATE(AVERAGE([Value]),ALLEXCEPT([Division]))
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |