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.

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

Hi Fistachpl please try this measure

 

measure=
CALCULATE (
    SUM ( 'phone length'[CallLength] ),
    FILTER (
        'phone length',
        NOT CONTAINS (
            SalesReps,
            SalesReps[Phone],
            'phone length'[RecipientNo]
        )
    )
)
Fistachpl's avatar
Fistachpl
Icon for Helper III rankHelper III
1 year ago

Does not work 😞