If Statement giving me a error message- please help

[Anonymous]

Hi,

I am getting below error

A single value for column 'DIRECTION' in table 'Data' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an agument.

as I am using below Dax Expression:

Partner Count = IF(Data[DIRECTION]<> blank() && SEARCH("I", Data[DIRECTION], 1,0)>0 , DISTINCTCOUNT(Data[GS_SENDER_ID]),
IF(SEARCH("O", Data[DIRECTION], 1,0)>0 , DISTINCTCOUNT(Data[GS_RECEIVER_ID]))

)

 for imeplementing the below logic:

If Direction = Inbound then COUNT DISTINCT (GS_SENDER_ID) else If Direction = Outbound then COUNT DISTINCT (GS_RECEIVER_ID)

[v-yuta-msft]

@Anonymous ,

So you are creating a measure, right? You may modify measure like below:

Partner Count =
IF (
    MAX ( Data[DIRECTION] ) <> BLANK ()
        && SEARCH ( "I", Data[DIRECTION], 1, 0 ) > 0,
    DISTINCTCOUNT ( Data[GS_SENDER_ID] ),
    IF (
        SEARCH ( "O", Data[DIRECTION], 1, 0 ) > 0,
        DISTINCTCOUNT ( Data[GS_RECEIVER_ID] )
    )
)

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Hi,

I am using the below DAX xpression:

Partner Count =
var InboundPartnerCount = CALCULATE(DISTINCTCOUNT(Test[GS_SENDER_ID]), Test[Direction] = "I")
var OutboundPartnerCount = CALCULATE(DISTINCTCOUNT(Test[GS_RECEIVER_ID]), Test[Direction] = "O")
return IF(MIN('Test'[Direction]) = "I", InboundPartnerCount, OutboundPartnerCount)

and getting the correct result and thank you very much for your interest for my problem.

Thanks,

Sandip Ghosh

[Anonymous]

Hi,

I am using the below DAX xpression:

Partner Count =
var InboundPartnerCount = CALCULATE(DISTINCTCOUNT(Test[GS_SENDER_ID]), Test[Direction] = "I")
var OutboundPartnerCount = CALCULATE(DISTINCTCOUNT(Test[GS_RECEIVER_ID]), Test[Direction] = "O")
return IF(MIN('Test'[Direction]) = "I", InboundPartnerCount, OutboundPartnerCount)

and getting the correct result and thank you very much for your interest for my problem.

Thanks,

Sandip Ghosh