Select Page
VIDEO: FILTER and ALL Inside CALCULATE Function

VIDEO: FILTER and ALL Inside CALCULATE Function

There are many different ways to use the CALCULATE function in DAX. Depending on a task at hand, you might want to put other DAX functions inside CALCULATE, creating nested functions. Two common functions that you put inside CALCULATE are the ALL and FILTER functions....
Dataflow: Sharing ETL Processes in Cloud

Dataflow: Sharing ETL Processes in Cloud

With many companies beginning to employ self-service BI, the issue of multiple users being able to work on building reports, often at the same time, comes to the forefront. Power BI Desktop is a great tool when there is one BI analyst or developer, who does everything...
VIDEO: FILTER and ALL Inside CALCULATE Function

VIDEO: DAX SUMX Function

The function SUMX has two parameters – a table and expression. The table parameter references a named table in a data model, while the expression completes a specified calculation row by row. SUMX is an iterator function, because it iterates through all the rows in a...