Set analysis

[risabhroy_03]

I have a field named Table source and when I am using the below expression

if([Table Source]='TIUIL962',Sum({<[Invoice_Date_GMT_Updated]={"$(vLastmonthdate)"}>} Quantity))

I get 0, but when I use Sum({<[Invoice_Date_GMT_Updated]={"$(vLastmonthdate)"}>} Quantity) and manually filter TAble Source then it works perfectly fine.

I want to use the if condition because I have multiple tables and different logics to sum the quantity.

Please help.

[micheledenardi]

Can you post an example of your dataset with some data?

Without this is very difficult to provide an answer

[nicu1996 · Accepted solution]

Try this:

Sum({<[Table Source] = {'TIUIL962'}, [Invoice_Date_GMT_Updated] = {"$(vLastmonthdate)"}>} Quantity)