Few Case studies Using ALL dax function

 Few case studies of using the ALL function in Power BI:

1. Sales performance dashboard: In a sales performance dashboard, you may want to create a measure that shows the total sales amount for the current quarter, regardless of the selected region or product. To achieve this, you can use the ALL function to remove the filter context on the "Region" and "Product" columns, and keep the filter context on the "Date" column. This will allow you to calculate the total sales amount for all regions and products in the current quarter.

2. Product mix analysis: In a product mix analysis, you may want to calculate the percentage of sales for each product category, based on the total sales amount. To achieve this, you can use the ALL function to remove the filter context on the "Product" column, and keep the filter context on the "Date" and "Region" columns. This will allow you to calculate the percentage of sales for each product category, regardless of the selected product.

3. Dynamic grouping: In a dynamic grouping scenario, you may want to group your data dynamically based on the user's selection. To achieve this, you can use the ALL function to remove the filter context on the column that you want to group by, and use the SWITCH function to dynamically group your data based on the user's selection. For example, you can group your data by region, product, or any other column, based on the user's selection.