topic Re: Based on two column filter conditions , need calculated column DAX expression in DAX Commands and Tips

Based on two column filter conditions , need calculated column DAX expression

sharath123 — Thu, 26 May 2022 07:07:42 GMT

Here we have Inspected dates as 26th Apr, 28th Apr, 3rd May, 4th May, 12th May, and 13th May (this is the latest date)
based on the vehicle number & latest date we need to get the max damage intensity value.

I have written dax expression as (calculated column)

max value of damage intensity = calculate(MAX(''Table1[damageIntensity]),ALLEXCEPT(Table1,Table1[Vehicle Number ]),KEEPFILTERS(LASTDATE(Table1[Inspected Date])))

But it is giving a different output
like for 26th Apr

and for 28th Apr

for each different date, it is giving different max damage intensity values. but I need output as max damage intensity value for the latest date (i.e 13th may)

Irrespective of each date, we need the max damage intensity value on the latest date. i.e value 6.
please help me to write/update my DAX expression.

Re: Based on two column filter conditions , need calculated column DAX expression

tamerj1 — Thu, 26 May 2022 07:43:38 GMT

Hi sharath123

you can use

max value of damage intensity = VAR VehicleTable = CALCULATETABLE ( Table1, ALLEXCEPT ( Table1, Table1[Vehicle Number] ) ) VAR MaxDate = MAXX ( VehicleTable, Table1[Inspected Date] ) RETURN MAXX ( FILTER ( VehicleTable, Table1[Inspected Date] = MaxDate ), Table1[damageIntensity] )

Re: Based on two column filter conditions , need calculated column DAX expression

sharath123 — Thu, 26 May 2022 08:44:28 GMT

Thanks tamerj1 It worked for me. you have given a detailed DAX expression, Thanks once again.