Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Problem with distinct values

Hello good morning I have a problem to solve the following question, I have a table of customers that I would like to take only the different ones and break them by week and month, only when I get th...
DAX
Distinct
  • Payeras_BI's avatar
    Payeras_BI
    5 years ago

    Hi Anonymous ,

     

    If I understood you correctly you have something like this:

     

     

    And would like this instead:

     

    If so adapt in the formula below the name of your 'Date table'[Month name column]:

     

     

    # Customers =
SUMX (
    VALUES ( 'Date'[Month Name] ),
    CALCULATE ( DISTINCTCOUNT ( F_Pedido_Item_SC6010[C6_CLI] ) )
)

     

     

Payeras_BI's avatar
Payeras_BI
Solution Sage
5 years ago

Hi Anonymous ,

 

If I understood you correctly you have something like this:

 

 

And would like this instead:

 

If so adapt in the formula below the name of your 'Date table'[Month name column]:

 

 

# Customers =
SUMX (
    VALUES ( 'Date'[Month Name] ),
    CALCULATE ( DISTINCTCOUNT ( F_Pedido_Item_SC6010[C6_CLI] ) )
)

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    thank you! it's work 🙂