Count Distinct Values for each day in a period

[muriloczs]

Hi,

I need to count distinct values for each day in a period, but when I choose the period of interest, the DAX function DISTINCTCOUNT only works for the entire period. Example:

In this case, I want to return the sum of the values, but if the column Date is removed, the function apply to the entire period, returning a undesirable result:

I am using the following formula:

Vendedoras*dias = CALCULATE(DISTINCTCOUNT(Tabela_Consulta_de_250_gestao[Nome]),REMOVEFILTERS(Tabela_Consulta_de_250_gestao[Nome]))

Obs.: I am using the REMOVEFILTERS function because it is a tooltip, and I want to compare filtered results with unfiltered, so I believe that part is not revelant.

Excuse me for my English, but the forum is very poor on my language.

Thank you in advance.

[amitchandak · Accepted solution]

@muriloczs , Try like

Vendedoras*dias = Sumx(Values(Tabela_Consulta_de_250_gestao[Date] ) , CALCULATE(DISTINCTCOUNT(Tabela_Consulta_de_250_gestao[Nome]),REMOVEFILTERS(Tabela_Consulta_de_250_gestao[Nome])))

[muriloczs]

Worked for me, thank you!