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, you might want to put other DAX functions, such as FILTER and ALL, inside CALCULATE. Two common functions that you put inside CALCULATE are the ALL and FILTER functions. Watch our...
Dataflow: Sharing ETL Processes in Cloud

Dataflow: Sharing ETL Processes in Cloud

With many companies beginning to employ self-service BI, the question of shared work comes to the forefront. Last year, Power BI introduced dataflows that aim to improve collaboration. Power BI Desktop is a great tool when there is one BI analyst working on one PBIX...
VIDEO: FILTER and ALL Inside CALCULATE Function

VIDEO: How to Use SumX Function in DAX

When people first start with Power BI, they are often confused about the two functions in DAX  – SUM and SUMX. Both functions are doing the aggregation and it may be hard to see the difference between the two. In this article, we take a look at the SUMX function...