Need help for dax dunction to count filter

[xiumi_hou]

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 = CALCULATE( SELECTEDVALUE(Calls[Calls_cstm.channel_c]),FILTER(Calls,Calls[date_start]=BaseLineBaseDate && Calls[direction]="Outbound" ))

return BaseLineBaseValue

The problem is, most of the people, it can give the result, there are some gave blank result but it does exist. Is there anything wrong with my dax function? I want to filter out is first outreach type... So I am finding the first outreach date and then look for the corresponding value.

Thanks!

[Anonymous · Accepted solution]

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]

UP

[Anonymous]

Hi

I wonder if your issue is related to the "blank" record created by Power BI when you are relating two tables and the one or many values for the relevant field is not found on one of the tables.

example

table 1

Name_number	Name
1	paul
2	john
3	Juan
4	Tomas
5	Ivan

table 2

Product Count	Name_number
10	1
2	3
6	10
6	8

Final report

Product count	Name
10	paul
2	Juan
12	blank

Is this your issue?

Thank you

Tomas

[xiumi_hou]

@Anonymous  Thanks for answering. Yes, I do can not found some records. But the records do exit in my database...

[Anonymous]

Can you share some sample of when it is not working?

Tomas

[xiumi_hou]

I 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]

UP