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 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)

 

 

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

3 Replies

  • 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

    • 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