Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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)
Solved! Go to 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 ,
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.
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
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
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |