Virtual table with new column and exprssion

[Anonymous]

Hi, 

Need help in DAX,

Test =

var AAA = ADDCOLUMNS(Transaction, "Test",   IF(Transaction[delivery_date]=[selected_date],1,0))

var A = CALCULATE(DISTINCTCOUNT('Transaction'[Customer_no]),FILTER('Transaction','Transaction'[Received_date] = [selected_date]),

FILTER(Transaction,AAA=1),   

FILTER(loginfact_transaction,loginfact_transaction[batch_date]=[selected_date]))

return A

Note = [selected_date] means whatever date i have selected in report that date dispaly in [selected_date] measure

Issue = I am facing issue in variable AAA,  I need 1 from variable AAA, How to wirte dax query for that, please help.

[amitchandak · Accepted solution]

@Anonymous , I think you need something like this

var A = CALCULATE(DISTINCTCOUNT('Transaction'[Customer_no]),FILTER('Transaction','Transaction'[Received_date] = [selected_date] && [delivery_date]=[selected_date]),
FILTER(loginfact_transaction,loginfact_transaction[batch_date]=[selected_date]))