Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Filtering text and ALL for date

Hi, 

 

I would like to get SUM for particular parts and keep it in CARD regardless of selection of month or year. 

 

Part Usage = calculate(abs(sum('Table1'[Qty])),filter('Table1',FIND("AA-",'Table1'[Product],,0)<>0))
 
Above is working, filtering only "AA-". 
However, I cannot get it working for date. I tried below but does not work as in SUM value keeps changing. 
 
Part Usage = calculate(abs(sum('Table1'[Qty])),filter('Table1',FIND("AA-",'Table1'[Product],,0)<>0), ALL(Table1[Date]))
 
Please advise the right Dax I need to use.  

 

  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    I am not sure if I understood your question correctly, but could you please try writing the below measure whether it suits your requirement?

     

    Part Usage =
CALCULATE (
    ABS ( SUM ( 'Table1'[Qty] ) ),
    FILTER ( ALL ( 'Table1' ), FIND ( "AA-", 'Table1'[Product],, 0 ) <> 0 )
)

1 Reply

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    4 years ago

    Hi,

    I am not sure if I understood your question correctly, but could you please try writing the below measure whether it suits your requirement?

     

    Part Usage =
CALCULATE (
    ABS ( SUM ( 'Table1'[Qty] ) ),
    FILTER ( ALL ( 'Table1' ), FIND ( "AA-", 'Table1'[Product],, 0 ) <> 0 )
)