DAX Nuggets

https://www.youtube.com/watch?v=V7XWLqdvzYM  

https://www.sqlbi.com/articles/displaying-filter-context-in-power-bi-tooltips/  

https://www.sqlbi.com/articles/dynamic-pareto-analysis-in-power-bi/  

  https://www.bing.com/videos/riverview/relatedvideo?q=dax%20calculatetable&mid=C21D26D975232B365236C21D26D975232B365236&ajaxhist=0

https://www.youtube.com/watch?v=d8Rm7dwM6gc   Creates a copy of Date table (PreviousDates) that will be filtered to the last 6 months of dates based on the slicer selection, use PreviousDates to filter Date table, create a calculation group that will calculate previous 6 months of SELECTEDMEASURE(), finally apply calculation item as a filter of the visual to render the previous 6 months based on slicer selection. Calculation item CALCULATE must REMOVEFILTER on Date table and KEEPFILTERS on PreviousDates Calculation Group starts at 14:00

https://www.sqlbi.com/tv/count-counta-countax-countx-dax-guide/  

https://www.sqlbi.com/articles/customizing-default-values-for-each-user-in-power-bi-reports/   Uses DATATABLE to create the default tables for Country/User and Calendar Year/User. Many-to-many relationships between default tables and dimension. Default table filters the dimension, 1-way. The logic is to check if Country or Calendar year is flitered outside of the visual; i.e. the matrix in this case. The Country or Calendar Year may be crossfiltered in the viual; e.g. Country is on the columns. We need to check if it's crossfiltered by for example a slicer. Use IF ( CALCULATE(ISCROSSFILTERED(Store[CountryRegion], ALLSELECTED()), ... -- -- If there is only one column used for the default value, then -- it is enough to apply the filter on the default value table and filter -- it with USERPRINCIPALNAME. The filter propagates to the related table and applies -- the default filtering. -- IF ( CALCULATE ( NOT ISCROSSFILTERED ( Store[CountryRegion] ), ALLS...

https://tabulareditor.github.io/TabularEditor/  

https://powerbi.microsoft.com/en-us/blog/using-username-in-dax-with-row-level-security/  

https://www.bing.com/videos/riverview/relatedvideo?q=tabular+editor&mid=B98FAE53BFBED4C8A008B98FAE53BFBED4C8A008&FORM=VIRE  

https://www.sqlbi.com/articles/syncing-slicers-in-power-bi/   Create measures that you can use to filter your slicers. You need to cast measures that return a boolean value to INT them=n check for 1 or 0.

 Slicers = FILTER ( {1}, FALSE )

https://www.daxpatterns.com/time-patterns/  

https://www.sqlbi.com/blog/marco/2020/08/10/announcing-dax-patterns-second-edition/  

  https://www.youtube.com/watch?v=gD8yLTtyW1k

https://www.youtube.com/watch?v=d9l97BfXbOA  

https://www.sqlbi.com/tv/selectcolumns-dax-guide/  

https://www.sqlbi.com/articles/filtering-weekdays-in-dax/   The real solution begins at 19:20