One of my favorite items in the March 2021 Power bi release is the update to the calculate function. Now we can use the OR Operator inside the CALCULATE function with out the need of calling the filter function within it.
Below code shows an example of how we used to apply the OR Operator within Calculate and the new way.
Before March 2021 Update we sue the combination of Filter and All and code was a little longer
[rulling amount or old way] =CALCULATE (
[Rulling Amount],
FILTER (
ALL ( ViolationCategory ),
ViolationCategory[Violation Category] = “Contraband”
|| ViolationCategory[Violation Category] = “CONDUCT”
)
)
After March 2021 CALCULATE Update, the code is now shorter
[rulling amount new way] =CALCULATE (
[Rulling Amount],
ViolationCategory[Violation Category] = “Contraband”
|| ViolationCategory[Violation Category] = “CONDUCT”
)
And as bonus here is another of writing the code below using the OR function
[rulling amount new way] =CALCULATE (
[Rulling Amount],
OR (
ViolationCategory[Violation Category] = “Contraband”,
ViolationCategory[Violation Category] = “CONDUCT”
)
)
