Power BI Sales Discrepancy Dive

Issue:

• Total sales for different time periods selected using separate date slicers are displaying the same results in Power BI.

Solution:

1. Create Separate Measures:

   • Create two separate measures for total sales based on each period selected using the date slicers.

2. Use CALCULATE Function with FILTER Context:

   • Inside each measure, use the CALCULATE function combined with FILTER to calculate total sales based on the selected period.

3. Apply Different Filter Context:

   • Specify different filter contexts for each measure by using the respective date columns from the attributed dim_date tables.

4. Sample Measures (Update based on your data model):

TotalSales_Period1 =
CALCULATE(
    SUM('Sales'[SalesAmount]),
    FILTER('Sales', 'Sales'[Date] IN DATESBETWEEN('dim_date1'[DateColumn], FIRSTDATE('dim_date1'[DateColumn]), LASTDATE('dim_date1'[DateColumn]))
)

TotalSales_Period2 =
CALCULATE(
    SUM('Sales'[SalesAmount]),
    FILTER('Sales', 'Sales'[Date] IN DATESBETWEEN('dim_date2'[DateColumn], FIRSTDATE('dim_date2'[DateColumn]), LASTDATE('dim_date2'[DateColumn]))
)

Benefits:

• By creating separate measures with unique filter contexts, you can accurately calculate total sales for each specified period based on the slicer selection.
• This approach ensures that each measure relates to the correct date slicer and provides distinct results.

By following the outlined solution, you should be able to resolve the issue of displaying the same total sales results for different time periods selected using separate date slicers in Power BI.