Forum Discussion

jacschZA's avatar
jacschZA
Advocate I
4 years ago
Solved

DAX remove filter but keeps the same filter..

Hi DAX community!   Hope someone can assist me with this one. No doubt it is possible, just been racking my brain and not winning.   So I have a classic inventory dataset. Excpet with sizes relat...
Need Help
  • MFelix's avatar
    MFelix
    4 years ago

    Hi jacschZA ,

     

    Create new table with only the Item codes:

     

    Now add the following measure to your model:

    Size Total = 
VAR sizeTable =
    FILTER (
        ALL ( DimProduct ),
        DimProduct[ItemCode] IN VALUES ( Products[ItemCode] )
    )
VAR Sizeselction =
    SELECTCOLUMNS ( sizeTable, "Size", DimProduct[Size] )
RETURN
    CALCULATE (
        SUM ( 'Fact'[Qty] ),
        FILTER ( ALL ( DimProduct ), DimProduct[Size] IN Sizeselction )
    )

     

    Has you can see below when you select BBBB the result is only 53:

     

     

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, jacschZA ;

 

I tried to restore your original model and requirements, but failed. Based on the information you provided, you can try the following :

Sales Qty for all Items Total =
CALCULATE (
    [Sales Qty for all Items],
    FILTER ( ALL ( 'Fact' ), [Store] = MAX ( 'Fact'[Store] ) )
)

 If not, can you provide a simple file after removing sensitive information?It makes it easier to give you a solution.

 

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.