DAX ALL Vs ALLSELECTED Vs ALLEXCEPT FIiter Functions | Hindi

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...

[@neerajbisht7778]

Hello, what would be the impact if we write DAX as Total Sales= SUM('Sales Summary'[Net Sales]), instead of using with CALCULATE? As output is same in both.

[@bhaveshsalunkhe]

This video on DAX ALL, ALLSELECTED, and ALLEXCEPT filter functions is the best one on KZbin. The explanations are clear and easy to understand. I really appreciate the effort that went into creating it.

[@lotusamaze1142]

You're very welcome!

[@monsheet]

too good...Long standing confusions got cleared..what a relief...make more such videos on DAX..Thank you

[@lotusamaze1142]

Glad you liked it

[@ahmadbilal2234]

Sir your teaching style is very good. God Bless you. You are doing wonderful job.

[@lotusamaze1142]

Thanks

[@TravelNerd93]

"Bestest" Vedio in KZbin for explaination of these Filter Functions. Thank you much Sir. Hats off to you👏

[@lotusamaze1142]

Thanks a ton

[@renukamatkar2093]

Thank you so much Sir. All confusion regarding ALL, ALLEXCEPT went away. Please create more videos on DAX.

[@lotusamaze1142]

Sure I will

[@raviranjansingh5527]

Great learning for me with your channel

[@lotusamaze1142]

Glad to hear that!

[@RamaKrishna-ll8iz]

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

[@prashantvarun23]

You are my favorite among all youtubers who are teaching power bi

[@YogeshSingh-kw8je]

thank you so much sir

[@lotusamaze1142]

So nice of you

[@SandipanSarkar-c8v]

Finished watching

[@jayantmishra4270]

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 ??

[@bidhanry9740]

ALL

[@yogitashinde8316]

Superb sir, thank you so much sir please upload more videos related to Dax.

[@lotusamaze1142]

Sure I will

[@jaspreetsingh7326]

Please create more valuable videos 💯💯💯💯💯💯💯💯💯💯❤️❤️❤️❤️❤️❤️❤️❤️

[@lotusamaze1142]

Sure

[@narenderyadav1727]

functions explained very well, sir appreciate your efforts.

[@lotusamaze1142]

Thanks

[@nakulbarot]

Now I can say that I understand this "All" related DAX function

[@lotusamaze1142]

Thanks

[@amanahmed6057]

Why you are using calculate everytime

[@lotusamaze1142]

Because Calculate function process the data row by row

[@ravanreturn123]

God bless you and do create more such videos

[@lotusamaze1142]

Sure and Thanks

[@jaspreetsingh7326]

Create videos on power bi service ❤️🥳

[@lotusamaze1142]

Sure

[@ravanreturn123]

Bhai mind blowing Bahut acche se or clear samjhate ho

[@lotusamaze1142]

Thanks

[@amanahmed6057]

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

[@kaushikdwivedi1845]

vo tabhi nahi dikhta ta jab santax wrong hota hai

[@LS8636]

You are an amazing teacher

[@lotusamaze1142]

Thanks

[@shrikantbadge3978]

आप ऑर अलग अलग व्हिडिओ bnaiye

[@lotusamaze1142]

Sure

[@jyotipatil5146]

Thank you so much💯💯👍👍

[@lotusamaze1142]

You're welcome 😊

[@shikharbhardwaj1352]

Very well understood

[@lotusamaze1142]

Thanks

[@chiragmeshram3670]

I find it very useful.

[@lotusamaze1142]

Glad to hear that!

[@Devloper56]

Nicely explain!!!!!!!!!!

[@lotusamaze1142]

Glad it was helpful!

[@shrikantbadge3978]

Thanks

[@lotusamaze1142]

Welcome

[@akshaypatil8155]

sir allselected ko kyu use karna hai....same result all() bhi dega, bus ALL() ke parenthesis ke andar columns ke naam likh lene.....

[@lotusamaze1142]

To achieve result there so many methods