Tag: Cumulative Sales DAX

A Deep Dive Into How The ALLSELECTED DAX Function Is Used In Power BI

By Sam McKay, CFA on May 17, 2020April 11, 2021

The ALLSELECTED DAX function inside Power BI is one of the more advanced functions that you can utilize within your reports and dashboards. You may watch the full video of this tutorial at the bottom of this blog. ALLSELECTED DAX function is a derivative of the ALL functions. So there’s ALL, ALLSELECTED and ALLEXCEPT. They

Posted in: Advanced DAX, ALL Function, ALLSELECTED, Cumulative Sales DAX, DAX Calculations, DAX Functions, DAX Measures, Forecasting

Data Visualization DAX Power BI Time Intelligence

Showing Cumulative Results vs Targets Only To Last Sales Date in Power BI

By Sam McKay, CFA on March 12, 2020March 31, 2021

In this tutorial I demonstrate how to create a cumulative visualization in Power BI, showing cumulative results versus targets or budgets. This is a really good visualization to show things over time. You may watch the full video of this tutorial at the bottom of this blog. But, in this example, I only want to