DAX Nuggets

https://www.youtube.com/watch?v=bGVLguWf4Ls   Article:  https://www.sqlbi.com/articles/when-to-use-keepfilters-over-iterators/

  https://www.sqlbi.com/articles/the-definitive-guide-to-allselected/ ALLSELECTED  can either return a table or it can remove filters and restore a previous filter context. In both cases, it does so by accessing and using the last shadow filter context left by an iterator on the stack of filter contexts.

https://www.sqlbi.com/tv/optimizing-an-old-sqlbi-article-and-logic-in-slicers-unplugged-4/   Rewrite old code: VAR NumOfSelectedCategories = COUNTROWS(VALUES('Product'[Category])) VAR CustomersAndCategories = SUMMARIZE(Sales, Sales[CustomerKey], Product[Category]) VAR CustomersWithNumCategories = GROUPBY(CustomerAndCategories, "@Categories",  SUMX(CURRENTGROUP(), 1)) VAR Result = COUNTROWS(FILTER(CustomersWithNumCategories, [@NumCategories] = NumOfSelectedCategories)) RETURN Result

https://www.youtube.com/watch?v=l5JX3G5Ntzk Create a filter by CROSSJOIN VALUES() and ALL(). VALUES picks up the slicer selection(s) and ALL() returns everything UNION the CROSSJOIN results

https://www.sqlbi.com/articles/computing-running-totals-in-dax/  

https://www.sqlbi.com/articles/summing-values-for-the-total/   Compute the number of working days where Sales > 0

https://www.sqlbi.com/articles/using-keepfilters-in-dax-updated/  

https://www.sqlbi.com/articles/filter-context-in-dax/  

https://www.sqlbi.com/articles/row-context-in-dax/  

https://www.sqlbi.com/articles/understanding-context-transition-in-dax/