topic Re: Problem with distinct values in DAX Commands and Tips

Problem with distinct values

Anonymous — Thu, 28 Jan 2021 12:54:20 GMT

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 the different ones of the week it is ok, but when I take the month and I try to filter if two month, it returns me the difference of two accumulated months, and I want to add the two months as: 1 month equal 100 distinct, 2 months equal100 distinct, 1 plus 2 equal 200, only he brings 1 plus 2 equal 100 because they are the same customers.

sorry for my english

Re: Problem with distinct values

Payeras_BI — Thu, 28 Jan 2021 14:36:24 GMT

Hi Anonymous,

How does your visualization look like? Do you have a Date table?

Re: Problem with distinct values

Anonymous — Thu, 28 Jan 2021 16:42:33 GMT

I already have a table, calendar, and I need my client table to bring the different month but when I filter through the calendar table with two selected months it will bring the sum of those months instead of the two months.

Re: Problem with distinct values

Anonymous — Thu, 28 Jan 2021 18:43:41 GMT

like this, the sum is not right, but why is he giving different in the 2 months together, and I need him to add the 2 months, but without removing the different ones, you have to take the different ones from each month and add

Re: Problem with distinct values

Payeras_BI — Thu, 28 Jan 2021 21:15:15 GMT

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] ) ) )

Re: Problem with distinct values

Anonymous — Fri, 29 Jan 2021 13:38:27 GMT

thank you! it's work 🙂