Skip to content

Phil Seamark on DAX

Data modelling and DAX

  • Home
  • Presentations
    • Creative Aggregations
    • Debug DAX like a Pro
  • DAX Games
  • About Phil Seamark
DAX 1-Column Fusion Pt 2

DAX 1-Column Fusion Pt 2

Posted on June 24, 2020June 24, 20204 Comments on DAX 1-Column Fusion Pt 2

I received feedback on my recent blog post on single-column fusion asking about a curious syntax used in the solution. I promised I would do a deeper dive on why it works in my next blog, so here it is. This article is also a fun reminder/refresher on how iterator functions work in Power BI. … Continue reading DAX 1-Column Fusion Pt 2

DAX 1-Column Fusion

DAX 1-Column Fusion

Posted on June 12, 2020June 12, 20205 Comments on DAX 1-Column Fusion

One approach to optimise DAX queries is to focus on the number of Storage Engine (SE) calls generated by a query and look for ways to provide the same result using fewer SE calls. If a query takes 30 seconds to run and makes hundreds of SE calls, reducing the number of SE calls almost … Continue reading DAX 1-Column Fusion

DAX KEEPFILTERS

DAX KEEPFILTERS

Posted on March 23, 2020March 23, 20207 Comments on DAX KEEPFILTERS

If you ever spend time looking at DAX generated by the Power BI Desktop Performance Analyser, you may notice a function called KEEPFILTERS appear from time to time. It’s not a function I find myself using often, so I thought I’d do a bit of digging to find out what it does and when it … Continue reading DAX KEEPFILTERS

Power BI – Dynamic Axis

Power BI – Dynamic Axis

Posted on February 17, 2020February 17, 20205 Comments on Power BI – Dynamic Axis

A question I come across in Power BI from time to time is how to configure a report to show an end-user a list of options, and then have visuals in the report use the selected item on the axis. There are a few ways this can get solved, such as using bookmarks. For this … Continue reading Power BI – Dynamic Axis

Posts navigation

Previous page Page 1 Page 2 Page 3 Page 4 … Page 10 Next page

Search

Recent Posts

  • Visualise your Power BI Refresh
  • DAX Formatter tool for Power BI Desktop
  • Use Visual Studio Code to Auto-format JSON
  • Disable auto-format of JSON in SSMS
  • Use Visual Studio Code to create Power BI External Tool

Archives

  • February 2021
  • November 2020
  • October 2020
  • August 2020
  • July 2020
  • June 2020
  • March 2020
  • February 2020
  • January 2020
  • December 2019
  • November 2019
  • October 2019
  • August 2019
  • July 2019
  • May 2019
  • May 2017
Phil Seamark on DAX

Back to top