Forum Discussion

sabariprabu's avatar
sabariprabu
Frequent Visitor
4 years ago
Solved

DAX Misbehaves for Total Calculations using ALL and Text Filter

Hi,   I have created below measure to get the sum of ActualBudgetDeviation by removing all the filters applied in ResourceHierarchy[ResourceHierarchyCol1] and then applying only one filter which is...
Need Help
Show and Tell
  • Fowmy's avatar
    Fowmy
    4 years ago

    sabariprabu 

    Add filter as follows:

    ActualBudgetDeviationALL :=
CALCULATE (
    [ActualBugetDeviation],
    FILTER (
        ALL ( ResourceHierarchy[ResourceHierarchyCol1] ),
        LEFT ( ResourceHierarchy[ResourceHierarchyCol1], 2 ) <> "01"
    )
)



Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
4 years ago

sabariprabu 

Add filter as follows:

ActualBudgetDeviationALL :=
CALCULATE (
    [ActualBugetDeviation],
    FILTER (
        ALL ( ResourceHierarchy[ResourceHierarchyCol1] ),
        LEFT ( ResourceHierarchy[ResourceHierarchyCol1], 2 ) <> "01"
    )
)