Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Anonymous
Not applicable

Virtual table with new column and exprssion

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.
 
 
 
1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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]))

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@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]))

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.