9 Interesting DAX Tricks

[@smitdedhia7816]

That reverse-direction filtering & filtering non-blanks with such a simple trick using CALCULATE() was amazing. There seems more to CALCULATE() than what meets the eye.

[@mohamedmossad9458]

The reverse-direction filtering with the FACT table is a neat trick, but It is very expensive as you are filtering with the expanded sales table. I prefer to use CROSSFILTER () Function.

[@pavankumarreddy189]

Thanks for sharing valuable information Chandeep

[@mehdihammadi6145]

Thanks for sharing. For the measures table trick I personally use *.Measures* this bring the Measures table on the top of the table list and I also aware of the 2 last ones but the other was totally new for me

[@QuLaZz]

Larger numbers could be written even easer, like in excel, 1e6 = 1*10^6..

[@DharamVids]

Ctrl+Shift+L was really helpful 👍

[@bradj229]

Control + Home was a good shortcut too

[@mohamedfouad7958]

Thanks for your efforts

[@Amitesh.Shrivastava]

quite interesting and learnable !! Thanks for sharing this

[@PRAS494]

Nice video... Please share your file of formulas.

[@Pooja-pd1ee]

Can't we use cross filter function to reverse filter?

[@shafa7668]

Hey trick at 7.40 - can we not use relate function to reverse the filter flow? Cheers in advance!!

[@Laxmanmane007]

MAXX trick with new table awesome

[@bedsup]

Another fantastic Video. On the 1:M Relationship trick, is it not just as easy to change the relationship to Bi-Directional?

[@GoodlyChandeep]

Easy but not recommended! :0

[@bedsup]

@@GoodlyChandeep can you explain why?. please?. Thanks

[@dilipinamdar5523]

Nice & useful video!!!

[@GoodlyChandeep]

Glad you think so!

[@gauthamnagaraj3983]

Missed Black Friday Sale, Hoping that offer comes again for New Year !

[@richardostrea7842]

Is there power query version of the Ctrl + Shift L shortcut?

[@GoodlyChandeep]

Hahaha.. No there isn't. Just delete the filtered step.

[@richard-social8125]

you have a global audience chief

[@kennethstephani692]

Great video!

[@Dravidan1971]

How to make percentage in dax if we have numbers

[@rahulshewale9206]

Thank you sir

[@djenral6153]

thanks for sharing .... really wonderful...!

[@DineshPal-nw1ss]

please provide source file ,then pratcing purpose