Posts

DAX Patterns: Like for Like Comparison

  https://www.daxpatterns.com/like-for-like-comparison/
Post a Comment
Read more

Unit Fiscal Week Sales Calculated Table and Query

Unit Fiscal Week Sales =   FILTER( ADDCOLUMNS( SUMMARIZE( 'Financial Summary', 'Unit'[UnitId], 'Calendar'[Fiscal Week End Date] ), "Weekly Sales", [Sales] ), [Weekly Sales] > 0 ) -- query to determine the Units that have sales > $0 in every week of the report date range DEFINE      VAR Units =          CALCULATETABLE (              VALUES ( Unit[UnitId] ) ,              Unit[Market] = "Domestic" ,     -- report filter              Unit[Brand] = "Carl's Jr."      -- page filter: "Carl's Jr." or "Hardee's"          )      VAR ReportDateRange =          ...
Post a Comment
Read more

Understanding Data Lineage in DAX

  https://www.youtube.com/watch?v=Hqs0lJJq1YA
Post a Comment
Read more

When to Use KEEPFILTERS Over Iterators

  https://www.sqlbi.com/articles/when-to-use-keepfilters-over-iterators/
Post a Comment
Read more

Managing "all" Functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT

https://www.sqlbi.com/articles/managing-all-functions-in-dax-all-allselected-allnoblankrow-allexcept/  
Post a Comment
Read more

Using the SELECTEDVALUE function in DAX

https://www.youtube.com/watch?v=Zhp1fAfN8Hw   https://www.sqlbi.com/articles/using-the-selectedvalue-function-in-dax/ Example of how to take a column from a dimension and render it in the VALUES area of a matrix. In one case uses CROSSFILTER.
Post a Comment
Read more

Paginated Report Resources

  https://hatfullofdata.blog/paginated-report-resources/
Post a Comment
Read more