DAX Help

[pmadam]

How do i acheive below condition in DAX measure.

BusDay is from one table and remaining dates come from different table.In between these two tables there is one active relationship between order date and busday and remainig two values are inactive relationships with Busday.

Thanks,

Prathy

[amitchandak]

@pmadam ,

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

You can actually make it work like

New Measure =
countx(summarize(filter(table,table[order_date]<=max(Table2[Bus Day]) && Table[start date]<=max(Table2[Bus Day])
&& Table[end date]>=max(Table2[Bus Day])), Table[Order-Line]),[Order-Line])

As we need an aggregated column from another table in the measure we can use related /min /max depend on the relation.

Order -line is force the row context of like , there can be more group bys

[pmadam]

Hi @amitchandak,

Thankyou so much for your reply.

I have created below measure as mentioned and added in below visual. It gives me blank data

Test =

countx(summarize(filter('DailySnapshot','DailySnapshot'[col_OrderDate] <=max ('BusinessCalendar'[col_Date]) && 'DailySnapshot'[col_StartDate] <=max('BusinessCalendar'[col_Date]) && 'DailySnapshot'[col_EndDate]>=max('BusinessCalendar'[col_Date])), 'DailySnapshot'[Order-Line]),[Order-Line])

[amitchandak · Accepted solution]

@pmadam 

Try

Test =

countx(summarize(filter(all('DailySnapshot'),'DailySnapshot'[col_OrderDate] <=max ('BusinessCalendar'[col_Date]) && 'DailySnapshot'[col_StartDate] <=max('BusinessCalendar'[col_Date]) && 'DailySnapshot'[col_EndDate]>=max('BusinessCalendar'[col_Date])), 'DailySnapshot'[Order-Line]),[Order-Line])