Forum Discussion

Edgar_massa's avatar
Edgar_massa
Helper II
3 years ago
Solved

Average with ALL()

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 som...
Need Help
Edgar_massa's avatar
Edgar_massa
Helper II
3 years ago

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's avatar
aj1973
Community Champion
3 years ago

Add a new measure

 

  • Edgar_massa's avatar
    Edgar_massa
    Helper II
    3 years ago

    excellent bro

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

  • Edgar_massa's avatar
    Edgar_massa
    Helper II
    3 years ago

    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's avatar
    aj1973
    Community Champion
    3 years ago

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

     

    Welcome