Need to find count of "Frequency occurrence" greater than 1

[ashaykohad]

Need to count frequency of Occurrence before certain date

Example,

Input
Name          Date                        
Test1           29-01-2022               
Test2           30-01-2022               
Test3           30-01-2022               
Test1           30-01-2022               
Test1           31-01-2022               
Test4           01-02-2022               
Test3           01-02-2022               
Test5           02-02-2022


Name          Date                        count Frequency (Name)
                                                   (this column is not availble in the table and caluculatin this is not working with 5L+ Entries)
Test1           29-01-2022               1
Test2           30-01-2022               1
Test3           30-01-2022               1
Test1           30-01-2022               2
Test1           31-01-2022               3
Test4           01-02-2022               1
Test3           01-02-2022               2
Test5           02-02-2022               1

Required Output
Count of Frequency greater than 1 = 3

Thanks in Advance.

[JirkaZ · Accepted solution]

This should be just a simple count of rows with specific criteria.

Frequency := 

VAR _Test = Table[Name]
VAR _Date = Table[Date]
RETURN

CALCULATE(COUNTROWS(ALL(MyTable)), 
MyTable[Name] = _Test,

MyTable[Date] <= _Date)

[ashaykohad]

didn't understand MyTable??
Is this measure or  formula for column?

[JirkaZ]

It's a formula for a custom column. And since I don't know how your table is called, I used "MyTable" instead. 

[amitchandak]

@ashaykohad , Create  a measure like

Sumx(filter(addcolumns(summarize( Table, Table[Name], Table[Date]), "_1", count(Table[Name])), [_1] >1), [Test])

[ashaykohad]

What is last [Test]!!