DAX ALL Vs ALLSELECTED Vs ALLEXCEPT FIiter Functions | Hindi
HTML-код
- Опубликовано: 5 сен 2024
- This video in hindi helps you to understand the filter and value functions in DAX. How the filter function ALL, ALLEXCEPT, ALLSELECTED works and what are their significance.
DAX Hindi Playlist : • DAX Hindi
DAX English Playlist : • DAX English
Power BI Hindi Playlist : • Power BI Tutorials-Hindi
Power BI English Playlist : • Power BI Tutorials-Eng...
#powerbi #powerbidax #powerbidaxfunction #powerbidashboard #powerbitutorial #powerbiforbeginners #dax #daxfunctions
Download Data File
education.myst...
Sir your teaching style is very good. God Bless you. You are doing wonderful job.
This video on DAX ALL, ALLSELECTED, and ALLEXCEPT filter functions is the best one on RUclips. The explanations are clear and easy to understand. I really appreciate the effort that went into creating it.
You're very welcome!
"Bestest" Vedio in RUclips for explaination of these Filter Functions. Thank you much Sir. Hats off to you👏
Thanks a ton
too good...Long standing confusions got cleared..what a relief...make more such videos on DAX..Thank you
Glad you liked it
You are my favorite among all youtubers who are teaching power bi
Thank you so much Sir. All confusion regarding ALL, ALLEXCEPT went away. Please create more videos on DAX.
Sure I will
Bhai mind blowing
Bahut acche se or clear samjhate ho
Thanks
Great learning for me with your channel
Glad to hear that!
functions explained very well, sir appreciate your efforts.
Thanks
You are an amazing teacher
Thanks
Superb sir, thank you so much sir please upload more videos related to Dax.
Sure I will
God bless you and do create more such videos
Sure and Thanks
Finished watching
thank you so much sir
So nice of you
I find it very useful.
Glad to hear that!
Please create more valuable videos 💯💯💯💯💯💯💯💯💯💯❤️❤️❤️❤️❤️❤️❤️❤️
Sure
Thank you so much💯💯👍👍
You're welcome 😊
Very well understood
Thanks
Now I can say that I understand this "All" related DAX function
Thanks
Nicely explain!!!!!!!!!!
Glad it was helpful!
Create videos on power bi service ❤️🥳
Sure
Hi
Can you help me to solve this question ??
which function is used to display the total sales in the card chart unsliced by an slicers ??
ALL SELECTED
ALL
ALL EXCEPT
ALL OF THE ABOVE
Which option I have to select ??
ALL
Thanks
Welcome
Sir 1 doubt hai
kai baar me jab new measure par click karta hu toh mujhe auto suggestion nahi dikhata powerbi
kya iska koi solution hai aapke pass ki aisa kyu ho raha hai
vo tabhi nahi dikhta ta jab santax wrong hota hai
आप ऑर अलग अलग व्हिडिओ bnaiye
Sure
Why you are using calculate everytime
Because Calculate function process the data row by row
sir allselected ko kyu use karna hai....same result all() bhi dega, bus ALL() ke parenthesis ke andar columns ke naam likh lene.....
To achieve result there so many methods
shared data and used data for explanation are different.
for explanation below data is used
Country Product Qty Sold Year of Sales Unit Price Gross Sale Unit Cost Net Sales Profit
Canada Pen 20 2019 21 420 20 400 20
Germany cpu 15 2019 2 30 1 15 15
France pencil 1999 2018 5 9995 3 4000 5995
Germany Mouse 350 2019 7 5500 1 4000 1500
Mexico Mouse 12 2018 13 156 8 96 60
Germany pad 7 2020 12 84 10 70 14
Germany pad 15 2019 3 45 1 15 30
Canada cpu 120 2020 44 5280 40 4800 480
France cpu 15 2019 21 6000 11 4800 1200
Germany Pencel 67 2018 34 2278 20 1340 938
Mexico Pencel 22 2020 21 462 11 242 220
France pen 12 2019 56 672 23 276 396
Mexico pen 15 2019 55 825 22 330 495
Germany cpu 20 2019 77 1540 33 660 880
Canada Pad 800 2018 89 6000 81 5000 1000