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
Anonymous
6 years agoNot applicable
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