Count number of repetitions but count 1 time if same date

[majo23]

Hi everyone,

Im making a measure that let you count the number of repetitions but if they have the same date then count it has 1 for that day

Count =

CALCULATE (

    COUNT(Table[LastUpdatedBy]),

    FILTER (

        Table,

        Table[CutDate] <> Table[CutDate]

))

Countoneperday.pbix

If someone could help me I will appreciated

Thanks MJ

[Arul]

@majo23 ,

Can you share the sample data?

Thanks,

Arul

[majo23]

Thanks for the reply, I made an update with the example file

[Arul]

@majo23 ,

I am not able to download, can you just post the picture of the table?

Thanks,

Arul

[majo23]

Hi @Arul I add a picture, also you should be able to download the report if you want

[johnyip · Accepted solution]

Hi @majo23 , please try this.

Count = 
VAR CurrentLastUpdatedBy = MAX(Sheet1[LastUpdatedBy])
VAR StagingTable = SUMMARIZE(FILTER(ALLSELECTED(Sheet1),
                                    Sheet1[LastUpdatedBy] = CurrentLastUpdatedBy),
                             Sheet1[LastUpdatedBy],
                             Sheet1[CutDate],
                             "Dummy_Count", 1
                   )
Var Result = COUNTX(StagingTable,[Dummy_Count])
Return
Result

[majo23]

Thank you very much @johnyip this works like a charm