Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |