Multiple column references for FILTER

[kumsha1]

Hi,

VALUES can accept single column reference in FILTER... So, how can i rewrite below DAX to pass multiple column references for FILTER?, to pass another column as highlighted in RED. TIA for your help. Cheers

SUMX(FILTER(VALUES(SHIPPING[DISCHARGE_COMMENCE],SHIPPING[SHIPMENT_NO]),[DATEDIFF]>=0),[TA_WEIGHTOMETER])

[Anonymous]

Hi @kumsha1 ,

I don't quite understand the formula. Can you show more details?

Best Regards,

Jay

[amitchandak]

@kumsha1 , Not very clear what you want from the formula.

Try like SUMX(FILTER(Summarize(SHIPPING[DISCHARGE_COMMENCE],SHIPPING[SHIPMENT_NO],"_1",[DATEDIFF],"_2",[TA_WEIGHTOMETER]),[_1]>0),[_2])

[kumsha1]

@amitchandak , i have below error

Requirement is to filter the values by multiple columns to get the correct aggregation.

[niteshtrehan89]

function=

var x= VALUES(SHIPPING[DISCHARGE_COMMENCE]

var y= VALUES(SHIPPING[SHIPMENT_NO])

return

SUMX(FILTER(x,y,[DATEDIFF]>=0),[TA_WEIGHTOMETER])

[kumsha1]

Hi @niteshtrehan89 , thanks for your quick response.

I tried creating variables as mentioned but the DATEDIFF is not being accepted with error 'unexpected parameter'.