Forum Discussion

Ras_Ile's avatar
Ras_Ile
Icon for Advocate I rankAdvocate I
2 years ago
Solved

DAX expression that ignores specific filter/slicer

Dear community, This seems like an easy-fix, but I am not able to come up with how to deal with this issue. I have a fact table (let's call it [f_Sales]).  In this table is a column. Let's cal...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Please Try this measure. 

     

     

    SalesCategory=
CALCULATE(
    [YourKPI],
    FILTER(
        ALL('f_Sales'[SalesCategory]), 'f_Sales'[SalesCategory] IN {"A", "B"}
    )
)

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Please Try this measure. 

 

 

SalesCategory=
CALCULATE(
    [YourKPI],
    FILTER(
        ALL('f_Sales'[SalesCategory]), 'f_Sales'[SalesCategory] IN {"A", "B"}
    )
)