Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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]))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |