topic Fixed value in column in DAX Commands and Tips

Fixed value in column

jkoclejda — Fri, 26 Jan 2024 15:04:08 GMT

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

Re: Fixed value in column

bhanu_gautam — Fri, 26 Jan 2024 15:20:00 GMT

jkoclejda , Could you please explain how area is getting calculated

Re: Fixed value in column

Anonymous — Mon, 29 Jan 2024 08:53:28 GMT

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.

Re: Fixed value in column

jkoclejda — Mon, 29 Jan 2024 14:14:03 GMT

I tried with all and it works. Thanks!