Forum Discussion

Thiagops's avatar
Thiagops
Icon for Helper II rankHelper II
3 years ago
Solved

Ambiguity when relating tables

Good morning, I need to know how many customers a seller registered in the month. I have the following tables: - Calendar (Related to outgoing invoice) - Sellers (related to customers) - Cust...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Thiagops 

    You are right. Please try

    Cadastro de NOVOS clientes2 =
CALCULATE (
    DISTINCTCOUNTNOBLANK ( 'CLIENTE (CARTEIRA)'[CLI_CODIGO] ),
    'CLIENTE (CARTEIRA)'[Registration Date] IN VALUES ( CALENDARIO[Date] )
)
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Thiagops 
Please try

New customer registration =
CALCULATE (
    DISTINCTCOUNTNOBLANK ( 'CUSTOMER (WALLET)'[CLI_CODIGO] ),
    CROSSFILTER ( 'Calendar'[Date], 'Exit invoice'[Date], BOTH )
)
Thiagops's avatar
Thiagops
Icon for Helper II rankHelper II
3 years ago

Still the same result

  • Thiagops's avatar
    Thiagops
    Icon for Helper II rankHelper II
    3 years ago

    I also tried with USERELATIONSHIP, but it didn't work

    • tamerj1's avatar
      tamerj1
      Icon for Community Champion rankCommunity Champion
      3 years ago

      Thiagops 

      Apologies, that was a mistake. Please try

      New customer registration =
      CALCULATE (
      DISTINCTCOUNTNOBLANK ( 'CUSTOMER (WALLET)'[CLI_CODIGO] ),
      CROSSFILTER ( Customer[Customer Key], 'Exit invoice'[Customer Key], BOTH )
      )

      • Thiagops's avatar
        Thiagops
        Icon for Helper II rankHelper II
        3 years ago

        The result has changed as the data slices change, but still the values ​​are wrong.
        The tables CLIENTE (CARTEIRA) and NF_SAIDA (CARTEIRA) are related by column CLI_CODIGO does it interfere?
        The code I used now was:

        Cadastro de NOVOS clientes2 =
        CALCULATE(
        DISTINCTCOUNTNOBLANK('CLIENTE (CARTEIRA)'[CLI_CODIGO]),
        CROSSFILTER('CLIENTE (CARTEIRA)'[CLI_CODIGO],'NF_SAIDA (CARTEIRA)'[CLI_CODIGO],Both))