Skip to content

Phil Seamark on DAX

Data modelling and DAX

  • Home
  • DAX Games
  • About Phil Seamark

Category: Relationships

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

Overriding slicers

Overriding slicers

Posted on February 5, 2020February 5, 202012 Comments on Overriding slicers

A question I’ve received a couple of times recently is how to override slicer selections in Power BI visuals. Or more specifically, if the user selects a specific item in a slicer (or filter), how can I show data for other items a visual that may be related by my selection. An example of this … Continue reading Overriding slicers

Clean data = faster reports

Clean data = faster reports

Posted on November 28, 2019November 28, 20193 Comments on Clean data = faster reports

Did you know, Analysis Services (the engine behind Power BI) keeps track of the number of referential integrity (RI) issues in your model? It uses this information to decide if some calculations can take advantage of specific optimisations. When RI issues exist in an IMPORT model, complex expressions will not be able to use all … Continue reading Clean data = faster reports

Creative Aggs Part VI : Shadow Models

Creative Aggs Part VI : Shadow Models

Posted on November 15, 2019November 15, 20198 Comments on Creative Aggs Part VI : Shadow Models

This post is the last in this series (for now) and describes a technique used to enhance performance in Power BI models that use Aggregate Awareness. I hope you’ve enjoyed the series as much as I have writing and sharing. I will no doubt add more articles in the future but need to pause this … Continue reading Creative Aggs Part VI : Shadow Models

Posts navigation

Page 1 Page 2 Next page

Search

Categories

  • Advanced
  • Aggregations
  • Analysis Services
  • Blog
  • Calculation Groups
  • Columns
  • Composite Models
  • Data Modelling
  • DAX
  • Direct Query
  • Distinct Count
  • Easy
  • Filtering
  • Inventory
  • Medium
  • Optimise
  • Performance
  • Power BI
  • Power BI Refresh
  • PowerShell
  • Relationships
  • SSMS
  • Time Intelligence
  • TMSL
  • TOM
  • Uncategorized
  • VS Code

Recent Posts

  • Using PowerShell to create Calculation Groups in Power BI Desktop
  • Power BI Storage Modes for Aggregations
  • Power BI Multiple Aggregations tables
  • Intro to Power BI Aggregations
  • DAX : Count number of last known state
Phil Seamark on DAX

Back to top
 

Loading Comments...