Calculate Max Value on each date in line chart

[Anonymous]

Hi I was to calculate maximum of a value on each date , and selected slicers values (load name and Bank_R) on the line chart . Currently it is giving me maximum of all on a bank date but ignoring bank_r and load name values. How to cater that ? 

I am using this DAX measure :

maximum_controlled_deviation =

CALCULATE(MAX('SLA_Reporting_View'[Controlled_Deadline_Deviation_]),ALLEXCEPT('SLA_Reporting_View','SLA_Reporting_View'[Bank_DATO_K_Formatted])

)

[dedelman_clng · Accepted solution]

Hi @Anonymous -

You can add multiple columns to ALLEXCEPT

maximum_controlled_deviation =
CALCULATE (
    MAX ( 'SLA_Reporting_View'[Controlled_Deadline_Deviation_] ),
    ALLEXCEPT (
        'SLA_Reporting_View',
        'SLA_Reporting_View'[Bank_DATO_K_Formatted],
        'SLA_Reporting_View'[Bank_R],
        'SLA_Reporting_View'[Load Name]
    )
)

Alternately you can put the slicer values for Bank_R and Load Name into variables via SELECTEDVALUE, then apply them as filters inside the CALCULATE.

Hope this helps

David

[Anonymous]

Putting everything in ALLEXCEPT worked! Cheers & Thanks 🙂