Count unique values with criteria for each day

[Anonymous]

Hello everyone,

Please I want a way to make a distinct count by criteria for each day during the month.

Example: 

Thank you in advance.

[rocky09]

I am not sure if I understood your question.

We have created a custom column that will create the Identifier. So, it should work. May be you can test with some more data. Btw, first try then see, if the above one solution that I have provided is not working, you can wait for some other's solution.

Cheers

[rocky09 · Accepted solution]

sorry, it was the wrong table.
here is the correct one.

DistinctCountofSameID on Same day = 
           CALCULATE(DISTINCTCOUNT( 'db'[Identfier]),
                db[STATUS]="Accepted",
               KEEPFILTERS('db'[STATUS]="Accepted"))

[Anonymous]

The solution works (y)?
Last question in case there are several criteria it will be like this?

DistinctCountofSameID on Same day =

           CALCULATE(DISTINCTCOUNT( 'db'[Identfier]),

                         db[STATUS]="Accepted", db[criteria2]="criteria2",

                         KEEPFILTERS('db'[STATUS]="Accepted",db[criteria2]="criteria2",))

[rocky09]

Try this:
Create a Calculated Column

Identfier = 
CONCATENATE('db'[ID CLT] ,'db'[DATE])

then create this measure

DistinctCountofSameID on Same day = 
           CALCULATE(DISTINCTCOUNT( 'db'[Identfier]),
                sumtable[STATUS]="Accepted",
               KEEPFILTERS('db'[STATUS]="Accepted"))
               

[Anonymous]

Thanks a lot.
What is "sumtable", for me it's grey?

[Anonymous]

Failed to resolve the name "sumtable". This is not a valid table, function or variable name.

[Ashish_Mathur]

Hi,

Create a Calendar Table.  Create a relationship from the Date column of the Data Table to the Date column of the Calendar Table.  To your Table visual, drag Date column from the Calendar Table.  Write this measure

Measure = calculate(distinctcount(Data[ID CLT]),Data[Statut]="Accepted")

Alternatively, you may create a slicer of Statut and select Accepted in that slicer.  Then write this measure

Measure = distinctcount(Data[ID CLT])

Hope this helps.

[Anonymous]

Hello,

I didn't quite understand the solution, but in the end I want a result like this

Thank you very much.

[Ashish_Mathur]

Hi,

What problem do you face when implementing my solution?

[rocky09]

So as per your above example, for 3rd, you want to see 3 as Accepted and for 4th 3 as Accepted?

[Anonymous]

First of all, thank you for your answer.
No I want the same result.
for the 3rd, I want to see 2 as accepted and for the 4th 2 as accepted.