Skip to content

Insight Quest

Brett Powell's Data & Analytics Blog

  • Home
  • Frontline Analytics
    • On-Site Training
    • BI Assessment
    • Corporate Site
  • Insight Quest
    • Tech Event Schedule
    • Boston BI User Group
    • Power BI User Group – Data Access
  • Resources
    • MSBI Books

Month: June 2016

Dynamic Filter Context Messaging for Power BI and SSAS Tabular

June 25, 2016 Brett Powell

Summary A user’s filter selections and the filters applied at the report level (not visible to the user) can be computed via DAX functions and then exposed

Continue reading

DAX Variables Design Considerations

June 19, 2016 Brett Powell

Summary DAX variables can be used to optimize performance of queries against SSAS Tabular, Power BI Desktop, and Power Pivot for Excel models by re-using a DAX expression multiple times

Continue reading

Always Be (thinking) Columnar Part II – FILTER()

June 11, 2016 Brett Powell

Summary: You can raise the performance of your DAX code by applying filters in a sequential order from the most selective to least selective. The goal is

Continue reading

Always Be (thinking) Columnar

June 6, 2016 Brett Powell

Summary: If you don’t read this blog post please just consider limiting your DAX metrics and queries to the specific columns and filter contexts required.

Continue reading

Blog Archive

Blog Topics

Tags

Analysis Services DAX Excel M MSBI Power BI Power BI Administration Power BI Desktop Power Pivot Power Query SSAS Tabular

Enter your email address to follow this blog and receive notifications of new posts by email.

Insight Quest

Blog Post History

June 2016
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
27282930  
« May   Jul »

Five Popular Posts

  • Power BI Project Example
    Power BI Project Example
  • Conditional Formatting for Card Visuals
    Conditional Formatting for Card Visuals
  • Refresh Power BI Datasets with PowerShell
    Refresh Power BI Datasets with PowerShell
  • Common Power BI Admin Scripts Part 1
    Common Power BI Admin Scripts Part 1
  • M Query Extension for Visual Studio Code
    M Query Extension for Visual Studio Code

Mastering Power BI

Power BI Cookbook

Top 10 Power BI Blog for 2019

Top 10 Power BI Blogs Badge

Microsoft Power BI Partner

Blog at WordPress.com.
Cancel

 
Loading Comments...
Comment
    ×