Fixed value in column

[jkoclejda]

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

[Anonymous · Accepted solution]

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. 

[jkoclejda]

I tried with all and it works. Thanks!

[bhanu_gautam]

@jkoclejda , Could you please explain how area is getting calculated