9 Interesting DAX Tricks

- - - - My Courses - - - -
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
- - - - Blogs - - - -
Max of Multiple Columns or Measures - www.goodly.co.in/max-multiple...
Phil's Blog (Measures Table) - dax.tips/2019/05/14/a-measure...
All DAX Keyboard Shortcuts - www.goodly.co.in/dax-keyboard...

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

[@Amitesh.Shrivastava]

quite interesting and learnable !! Thanks for sharing this

[@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

[@mohamedfouad7958]

Thanks for your efforts

[@DharamVids]

Ctrl+Shift+L was really helpful 👍

[@pavankumarreddy189]

Thanks for sharing valuable information Chandeep

[@kennethstephani692]

Great video!

[@Laxmanmane007]

MAXX trick with new table awesome

[@rahulshewale9206]

Thank you sir

[@QuLaZz]

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

[@shafa7668]

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

[@gauthamnagaraj3983]

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

[@dilipinamdar5523]

Nice & useful video!!!

[@GoodlyChandeep]

Glad you think so!

[@Pooja-pd1ee]

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

[@djenral6153]

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

[@bradj229]

Control + Home was a good shortcut too

[@PRAS494]

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

[@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

[@richardostrea7842]

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

[@GoodlyChandeep]

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

[@Dravidan1971]

How to make percentage in dax if we have numbers

[@richard-social8125]

you have a global audience chief

[@DineshPal-nw1ss]

please provide source file ,then pratcing purpose