Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |