DAX Functions, DirectQuery And Unrestricted Measures

By admin in Data & Analysis

If you use Power BI to connect to a data source such as SQL Server in DirectQuery mode, you’ll find that by default you cannot use the complete range of DAX functions inside your calculations. For example, here’s a screenshot from Power BI Desktop in DirectQuery mode with a measure where I’m trying to use the RankX() function:

Bron : Chris Webb’s BI Blog
Lees meer…

Gerelateerde artikelen:

  1. Power BI Desktop, Sort By Column And DAX Calculations That Use The All() Function
  2. Dynamic Formatting of Switch Measures
  3. Multiple Item Unit of Measures
  4. Invoking M Functions In Parallel Using List.ParallelInvoke()
  5. The DAX Unichar() Function And How To Use It In Measures For Data Visualisation

Related Articles.