Solved: Issue using Date measure to filter a summing measu... - Page 2

nkillia · ‎01-06-2020

I have created a Start Date measure to calculate the latest start date:

I am trying to use this date measure to filter data for a summing measure:

CALCULATE(

SUM(Data[Amount]),

FILTER(Data,Data[Date] >= [Start Date]))

This measure is returning the Sum of the amount from all years.

CALCULATE(

SUM(Data[Amount]),

FILTER(Data,Data[Date] >=DATE(2019,1,1))

This version of the measure is returning the correct amount.

Is there a way to filter the data using a Date measure?

Anonymous · ‎01-09-2020

Modify your MAX_Date measure as below

MAX_Date = CALCULATE(MAX(TEST1[Date]),FILTER(all(TEST1),TEST1[Type]<>"B")).

when we add "all" it takes your entire dataset irrespective of your filters.

PReviously we are simple checking with it with filters and it is evaluating MAX Date for each row.

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

Issue using Date measure to filter a summing measure