Power BI Tips

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

  https://www.youtube.com/watch?v=miiGlDWeamM Scenario is to use a ranking measure as a filter on a matrix visual. The filter is used to only return the top 2 based on rank. When the measure is included in the matrix, the results are correct. Problem is when the measure is not included in the matrix, the results are not correct. Solution adds zero to a measure to keep it from returning blank.

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

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

https://www.sqlbi.com/articles/from-sql-to-dax-filtering-data/  

  RM Average Sales for Units With Sales > $0 = -- Get the UnitIds. VAR Units = VALUES('Unit'[UnitId]) -- Get the Fiscal Week Num Overall for the Current Fiscal Week. This will be -- an incomplete week (we always want the last completed week). On the Tuesday -- morning refresh, the Fiscal Week Num Overall will increment to the next week -- which has just begun. VAR FiscalWeekNumber = CALCULATETABLE(     SUMMARIZE(     'Calendar',     'Calendar'[Fiscal Week Num Overall]     ), ALL('Calendar'),     'Calendar'[Current Fiscal Week] = TRUE() ) -- Get the list of the last 9 Fiscal Week End Dates prior to the current one. -- This is the date range to check for Sales > $0. VAR FiscalWeekEndDates = CALCULATETABLE(     SUMMARIZE( 'Calendar', 'Calendar'[Fiscal Week End Date]     ), ALL('Calendar'),     AND(...

https://www.sqlbi.com/articles/applying-a-measure-filter-in-power-bi/  

  https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/

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

  https://www.youtube.com/watch?v=lkHFpmA4SJ4 In this Power BI Tutorial, Patrick looks at how to dynamically filter by today's date. Using a date table, you can create a DAX measure that can then be used as a Power BI report-level filter to dynamically filter by today's date within Power BI Desktop

  https://www.sqlbi.com/articles/filtering-and-comparing-different-time-periods-with-power-bi/

https://www.sqlbi.com/articles/syncing-slicers-in-power-bi/   Create measures that you can put in the filter for slicers to limit the items in the slicer. Just check whether the table is NOT empty. For instance, you can filter a slicer on Color to just the colors that have actually been sold by checking whether the Sales table is NOT empty. MEASURE:  Slicer Sales = INT (NOT ISEMPTY ( Sales )) Add measure to the Filters on this visual for the slicer and specify Show items when the value is 1

  https://www.youtube.com/watch?v=wQ9DohPvx8Q Use case is to show sales for the last 12 months and the sales forecast for the next 12 months. Add a calculated column (e.g. 24 Month Reports) to the Calendar table to indicate whether the date is in the range of previous 12 months or next 12 months. The value will be 1 if TRUE or 0 if FALSE. Filter the visual to check if 24 Month Reports is 1.

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

  https://www.youtube.com/watch?v=o8K4Px_6AYQ Add measure to Filters on the slicer visual; e.g. MEASURENAME > 0

  https://exceleratorbi.com.au/filters-on-power-bi-slicers-wait-what/

  https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-report-filter

https://www.youtube.com/watch?v=NA2wlqfjX34     Difference between slicers and the filter pane.  Default to dropdown slicer. No query issued until you actually make a selection. Sync slicer: View, Sync Slicer Filter pane doesn't allow you to filter on selected pages.