Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Need help for Dax expression

Hi, I need to implement the below logic in DAX   If Direction = Inbound then COUNT DISTINCT (GS_SENDER_ID) else If Direction = Outbound then COUNT DISTINCT (GS_RECEIVER_ID)   and I have written ...
Need Help
PattemManohar's avatar
PattemManohar
Icon for Community Champion rankCommunity Champion
7 years ago

Anonymous Please try this..

 

CountResult = 

VAR _InboundCount = CALCULATE(DISTINCTCOUNT(Test[GS_SENDER_ID]),Test[Direction]="I")
VAR _OutboundCount = CALCULATE(DISTINCTCOUNT(Test[GS_RECEIVER_ID]),Test[Direction]="O")

RETURN IF(Test[Direction]="I",_InboundCount,_OutboundCount)
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi,

    I have used your expression and it gives me a error like below screen shot:

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      7 years ago

      Hi Anonymous,

       

      Add a MIN if that formula is the solution.

       

      if(MIN('Test'[Direction]) = "I",

       

      Best Regards,
      Dale