Topic: Power BI
-
This article shows techniques to obtain a ranking based on more than one column. The ranking can be both static and dynamic. Read more
-
Explore how you can hide columns and tables to Power BI users by using the Object Level Security (OLS) feature released in February 2021. By hiding objects, you also hide derived calculations like measures, calculated columns, and calculated tables. The… Watch now
-
This article describes how to use DAX Studio to capture DAX queries generated by Power BI. Analyzing DAX queries can be helpful to better understand performance issues, and to improve the writing of DAX queries. Read more
-
What are the differences between Power BI Desktop, Visual Studio, and Tabular Editor as modeling tools? Introducing the workspace is important to understand why Tabular Editor results in being more flexible and productive. Watch now
-
This article explains how to avoid circular dependency errors that can occur in DAX when two or more entities (calculated columns or calculated tables) reference one another in such a way that the engine cannot compute their value. Read more
-
This article shows how to add an additional “other” row to the selection obtained using the Top N filter in a Power BI report. Read more
-
This article explains the most common causes of the error, “A circular dependency was detected” in Power BI and Analysis Services. Read more
-
Analyzing table and column size is an important step in optimizing a data model for Power Pivot, Power BI, or Analysis Services Tabular. This article describes VertiPaq Analyzer, an Excel workbook to analyze detailed information extracted from Dynamic Management Views. Read more
-
When you apply a multiple selection to a slicer or to a filter, you obtain a logical OR condition between selected items. This article shows how to implement a logical AND condition in a measure instead of the standard OR… Read more
-
You can create static tables in DAX using the DATATABLE function. This article describes the syntax of this new feature and shows when and how to use it. Read more
