Forum Discussion
xiumi_hou
Post Partisan
6 years agoNeed help for dax dunction to count filter
Dear all, I have a dax function like below. And I have a sclier to filter each person. 1st outreach outbound = VAR BaseLineBaseDate = MIN(Calls[date_start]) VAR BaseLineBaseValue = CALCUL...
- Anonymous6 years ago
HI xiumi_hou ,
I think it should more be related to selectedvalue function, it will return blank when it returns multiple results, you can try to follow measure formula if it works:
1st outreach outbound = VAR BaseLineBaseDate = MIN ( Calls[date_start] ) RETURN CALCULATE ( SELECTEDVALUE ( Calls[Calls_cstm.channel_c], CONCATENATEX ( VALUES ( Calls[Calls_cstm.channel_c] ), [Calls_cstm.channel_c], "," ) ), FILTER ( Calls, Calls[date_start] = BaseLineBaseDate && Calls[direction] = "Outbound" ) )Regards,
Xiaoxin Sheng
xiumi_hou
Post Partisan
6 years agoI got the issue. The issue is For example, I have two records for the same person same date
Example,
Person 1 July, 18 3:00pm outreach=email
Person 1 July, 18 3:00 pm outreach =phone
Persno 1 August, 1st, 8:00 pm outreach=email
If the stituation is like above, the first outreach is at same day, same time, How can I get out the data?
Anonymous
xiumi_hou
Post Partisan
6 years agoUP