topic Re: Calculate Max Value on each date in line chart in DAX Commands and Tips

Calculate Max Value on each date in line chart

Anonymous — Tue, 22 Sep 2020 14:57:36 GMT

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])

)

Re: Calculate Max Value on each date in line chart

dedelman_clng — Tue, 22 Sep 2020 18:03:49 GMT

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

Re: Calculate Max Value on each date in line chart

Anonymous — Wed, 23 Sep 2020 05:28:39 GMT

Putting everything in ALLEXCEPT worked! Cheers & Thanks 🙂