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 

You are right. Please try

Cadastro de NOVOS clientes2 =
CALCULATE (
    DISTINCTCOUNTNOBLANK ( 'CLIENTE (CARTEIRA)'[CLI_CODIGO] ),
    'CLIENTE (CARTEIRA)'[Registration Date] IN VALUES ( CALENDARIO[Date] )
)
Thiagops's avatar
Thiagops
Icon for Helper II rankHelper II
3 years ago

tamerj1  thank you very much.
It was right. GOD reward you, you helped me a lot.

Does this that was done force a relationship?

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

    Thiagops 

    No that was just a filter that simulates a relationship