Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

If Statement giving me a error message- please help

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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

v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

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