March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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
Solved! Go to 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
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
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.
Hi @Edgar_massa
in your VAR _avg = CALCULATE(AVARAGEX(tf,[X]) , ALL())
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Did not work.
What can it be?
Please add tf in ALL(tf)
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Is it possibe you share your PBIX please?
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Is this what you want to see?
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
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
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
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
Add a new measure
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
excellent bro
But why can't I do the last calculate with the all there in the variables?
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
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
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
Sometimes DAX is a bit complex to understand that's why i sometimes take things for granted 😁
Welcome
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
93 | |
87 | |
85 | |
76 | |
49 |
User | Count |
---|---|
163 | |
148 | |
103 | |
74 | |
55 |