Want to take Max Values by Category that changes according to Date Sclicer

[aarshps]

I have a data source, where I need the maximum date's value by grouping according to a category. The problem is, the dataset changes according to a date slicer being applie. Is it possible to achieve it?

[Zubair_Muhammad · Accepted solution]

@aarshps

Try something on this pattern

Measure =
CALCULATE (
    MAX ( TableName[Date] ),
    ALLEXCEPT ( TableName, TableName[Category] )
)

[aarshps]

Yeah, it does work.

[aarshps]

I tried using the measure as you suggested, but it didn't work.

I'll explain the problem in detail. What I need is as shown below.

The above image show the data result when I apply 2 different date filters. First filter I apply is DateKey BETWEEN 20180301 AND 20180307, second one is BETWEEN 20180301 AND 20180306. In the second fitler, last status is Rejected, but in the first filter, Closed is the last one.

The measure that I need to create is SUM(Amount). But this Amount column above is something that I've written using SQL. So, the logic here is, when the latest Status is Rejected, then I need to calculate the Amount, it is simple. But I'm not able to write a DAX for this measure.

[v-shex-msft]

Hi @aarshps,

Can you please provide some sample data to test?

Regards,

XIaoxin Sheng