Forum Discussion
Fixed value in column
HI!
I have a visualization like this:
| area | supply_number | goods | goods_per_hour | area_average |
| A | 12345 | 52 | 2 | 4 |
| B | 12346 | 13 | 8 | 8 |
| C | 12347 | 85 | 3 | 3 |
| A | 12348 | 63 | 6 | 4 |
| D | 12349 | 78 | 9 | 9 |
I want to calculate the area_average. I tried multiple variants with summarize and summarizecolumns with grouuping by area but i always get the same values as goods_per_hour.
Do you know how should i calculate this to get average for area
Hi jkoclejda
I don't know what effect you want to achieve, and how your dax works.
I'm speculating that you need to use the all(), allselected(), allexcept(), and removefilter() functions to remove unwanted filtering effects:
Here's a blog about contextual filtering:
Understand the Filter Context and How to Control i... - Microsoft Fabric Community
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
How to Get Your Question Answered Quickly - Page 13 - Microsoft Fabric Community
Best Regards,
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
jkoclejda , Could you please explain how area is getting calculated
Hi jkoclejda
I don't know what effect you want to achieve, and how your dax works.
I'm speculating that you need to use the all(), allselected(), allexcept(), and removefilter() functions to remove unwanted filtering effects:
Here's a blog about contextual filtering:
Understand the Filter Context and How to Control i... - Microsoft Fabric Community
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
How to Get Your Question Answered Quickly - Page 13 - Microsoft Fabric Community
Best Regards,
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I tried with all and it works. Thanks!
