Category Archives: DAX

FILTER Functions for Power BI in DAX – Overview

By | 21. 3. 2020

FILTER functions (filtering functions) are used to get values from the table. Some functions enable additional filtering in a given table. These functions are often part of different functions as is nested parameter and enable dynamic calculations. They often serve as a value filter for function  CALCULATE. Mostly it is the case of typical member… Read More »

Aggregation in DAX – How Aggregations Work? + Function Overview

By | 21. 3. 2020

Aggregate functions in DAX language are used to get certain summarized or grouped data view. Thanks to this, we can edit high detail data in a certain column into more simple and reportable form using aggregation. We can for example sum up (SUM, SUMX) some financial metrics by individual category or express maximal/minimal (MAX, MAXX,… Read More »

DAX | SUM and SUMX – How to Perform Aggregation in DAX Language for Power BI

By | 11. 2. 2020

You probably noticed that there are many functions in DAX that are similar to Excel ones (as in article here). Contrary to Excel functions, DAX haves on strange thing. Some aggregate functions have another similar function ending with X – for example SUM and SUMX or COUNT and COUNTX. These functions often give same results… Read More »