Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 :
Solved! Go to 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
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
Putting everything in ALLEXCEPT worked! Cheers & Thanks 🙂
User | Count |
---|---|
60 | |
22 | |
18 | |
18 | |
16 |
User | Count |
---|---|
86 | |
54 | |
54 | |
38 | |
21 |