Now You See Me! Use cases of ALL DAX Function in Power BI
Among all the functions in DAX; the behavior of ALL function still seems mysterious for many. Many people, don’t use it at all and end up writing a very complicated calculation for a scenario that only one simple expression can do the same job. Some people, use it, but don’t exactly know how the function works, and get some unexpected results, and call it an error. In this article, I’m going to explain what ALL function is, how it can be used, and what are use cases of using such a function in DAX and Power BI. If you like to learn more about Power BI, read the Power BI book from Rookie to Rock Star.
Read the rest of the article from here: https://radacad.com/now-you-see-me-use-cases-of-all-dax-function-in-power-bi
Director (Department of Defence - RAAF)
6 年Michael Fridolfsson
Data & Analytics Senior
6 年This is one of the best free articles I've ever read about All function. Maybe just the part "use case for all function: controlling the interaction" is a little bit too difficult for a newbie, however really a good article! Thank you so much! P.s:Later I'll watch your last video on YouTube! :) P.s2: really love the title!