Average with ALL()

[Edgar_massa]

Good night sir,

I'm trying to create a measure to bring the value repeatedly, using the ALL function, I created a virtual table and I saw that it works more in the measure it doesn't work, could someone give me a solution?

measure

visual in which I want it to repeat the number for all lines

table that I created to validate and it worked

[v-rongtiep-msft]

Hi @Edgar_massa ,

Could you please provide more details with your desired output and pbix file without privacy inforamtion?

How to Get Your Question Answered Quickly 

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[aj1973]

Hi @Edgar_massa 

in your VAR _avg = CALCULATE(AVARAGEX(tf,[X]) , ALL())

[Edgar_massa]

Did not work.

What can it be?

[aj1973]

Please add tf in ALL(tf)

[Edgar_massa]

@aj1973 

Did not work

[aj1973]

Is it possibe you share your PBIX please?

[Edgar_massa]

https://drive.google.com/drive/folders/1GezBUaLHT_us5zf2zIzRO8ZxjVYqMmO6?usp=sharing

Siga o link @aj1973 

[aj1973]

Is this what you want to see?

[Edgar_massa]

@aj1973 

Yes, but I want it within the measure

[aj1973]

Sorry I don't understand your request. But if you need to see the avg inside your visual you will need to link your tables

Or show me the outcome you want to see

[Edgar_massa]

I created the virtual table to simulate and see if the value was correct, but I want to get only the avg_ variable within a measure for my visual, I don't want to create a virtual table to relate, understand?

Same in the print below

the result I want is this but within a measure

bringing the result equal to the column you asked if it was like I wanted

[aj1973]

Add a new measure

[Edgar_massa]

excellent bro

But why can't I do the last calculate with the all there in the variables?

[aj1973 · Accepted solution]

I invite you to watch these videos to better understand 😉

https://www.youtube.com/watch?v=lMuDz6ViU1w

https://www.youtube.com/watch?v=lX2ztEh3tuA

https://www.youtube.com/watch?v=Nm9x83J-SBk

[Edgar_massa]

I watched the videos, I understood the issue of the context filter and line filter, but I don't know if I understood it right in my case, if it's because the variable is constant, but anyway..

Thanks a lot for the help

[aj1973]

Sometimes DAX is a bit complex to understand that's why i sometimes take things for granted 😁

Welcome