Forum Discussion

Fistachpl's avatar
Fistachpl
Icon for Helper III rankHelper III
1 year ago
Solved

NOT INVALUES is not working

I have two tables: SalesReps with Columns Name, Phone Jan Kowalski, 48123456789 and PhoneLogs with Columns Caller, RecipientNo, CallLength and some other columns I have relation between bo...
INVALUES()
  • v-kathullac's avatar
    v-kathullac
    1 year ago

    Hi Fistachpl ,

    Thank you for reaching out to Microsoft Fabric Community Forum.

     

    here can calculate how many times each Sales Rep called another Sales Rep based on phone number here i have used TREATAS & LOOKUPVALUE function.

    CallsToSalesReps :=
    CALCULATE(
    COUNTROWS(PhoneCalls),
    TREATAS(VALUES(SalesRep[Phone]), PhoneCalls[RecipientNumber])
    )

    2)

    SalesRepName =
    LOOKUPVALUE(
    SalesRep[Name],
    SalesRep[Phone], PhoneCalls[RecipientNumber]
    )

     

    Regards,

    Chaithanya.

johnt75's avatar
johnt75
Icon for Super User rankSuper User
1 year ago

Try

_callLength =
VAR SalesRepNumbers =
    VALUES ( SalesReps[Phone] )
VAR Result =
    CALCULATE (
        SUMX ( PhoneLogs, PhoneLogs[CallLength] ),
        NOT PhoneLogs[RecipientNo] IN SalesRepNumbers
    )
RETURN
    Result
Fistachpl's avatar
Fistachpl
Icon for Helper III rankHelper III
1 year ago

It does not work, but I am not suprised as it is basically the same syntax I tried 😕

 

 

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    1 year ago

    What columns from which tables do you have in the table visual ?

    • Fistachpl's avatar
      Fistachpl
      Icon for Helper III rankHelper III
      1 year ago

      I have Name from table SalesReps and for those I want to calculate a measure. 

      • pravinW007's avatar
        pravinW007
        Regular Visitor
        1 year ago

        Can share your pbix file with sample expected output.

        Thanks,
        Pravin Wattamwar