DAX Nuggets

https://www.sqlbi.com/tv/different-types-of-many-to-many-relationships-in-power-bi/  

https://www.sqlbi.com/articles/relationships-in-power-bi-and-tabular-models/  

 Do not use in a measure because SUMMARIZECOLUMNS does not support context transition

 Use SUMMARIZE to do a "SELECT DISTINCT" then wrap with ADDCOLUMNS to return a measure value "GROUPED BY" the SELECT DISTINCT This is due to issues in the DAX engine

  https://www.youtube.com/watch?v=1QqXJI-algU

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

  https://www.youtube.com/watch?v=oiCVBUQenls You could add a filter to the slicers "where MEASURE is not blank" A more efficient way is to add a measure: INT (NOT ISEMPTY (tablename)) and check for Value is 1. Add these measures to a "measures" table. Create it with: Slicers = FILTER( { 1 } , FALSE ) Show TOP N sales in slicer: SliceTopProducts = RANKX( ALLSELECTED ('Product'), [Sales Amount] ) Filter on Value is less than or equal N

https://www.youtube.com/watch?v=1yv5srlqgmI   Add a filter on a visual (e.g. slicer) where a measure is not blank to limit the filters to ones that have data.

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

  https://www.youtube.com/watch?v=AdLDYohLeJc Create a new table in DAX 'MTD/QTD/YTD Selection' that has the following rows and columns: Selection = MTD, QTD or YTD Rows for every date value in the MTD, QTD and YTD,  User can choose 1 value for Selection (MTD, QTD or YTD). 'MTD/QTD/YTD Selection' has a many-to-1 relationship with the Calendar table.

 Reference: SQLBI DAX Patterns, Comparing Different Time Periods You have a Date table and a Comparison Date table in order to compare a measure using 2 different date ranges. In the Data Model, there is a many-to-1 relationship between Date and Comparison Date and the relationship is inactive. The relationship is activated in CALCULATE; e.g. CALCULATE([Sales Amount], REMOVEFILTERS('Date', USERELATIONSHIP('Date'[Date], 'Comparison Date'[Comparison Date]

https://www.daxpatterns.com/parent-child-hierarchies/  

https://www.daxpatterns.com/hierarchies/  

https://www.sqlbi.com/articles/understanding-group-by-columns-in-power-bi/  

  https://www.sqlbi.com/articles/introducing-summarizecolumns/