How to countrows based on two columns

[adii]

Hello , I’m wondering how solve technical problem with distinctly values. I would like show and count only distinct rows based on two columns. Problem shows bellow in random table

Date

Country

Port

Name

2023-01-01	USA	Tex	Bat
2023-01-01	USA	Tex	Cat
2023-02-05	Qatar	Al	Al bat
2023-06-07	USA	Tex	Bat
Etc	Etc	Etc	Etc

I would receive number of rows like below

Bat 2

Cat 1

Al bat 1

Countrows has to be depending on Date and Name columns

Thanks all

[Ritaf1983 · Accepted solution]

Hi @adii 

For the visual with just name and count, regular count works accurately :

If the desired result is the first table with adding count, than you can create a measure with the formula :

count 2 = CALCULATE([regular countrows],ALLSELECTED('Table'[Port],'Table'[Date]))

Link to the sample file 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[adii]

Hello, thanks you but i wasn't too clear . I have more complicated issue . Below i modified my table

Date Exit	Port	Name	Update
2023-01-01	TEX	Cat	2023-02-01
2023-01-14	TEX	Bat	2023-02-01
2023-01-14	AI	AI bat	2023-02-01
2023-01-01	TEX	Cat	2023-02-02
2023-01-14	TEX	Bat	2023-02-02
2023-01-14	AI	AI bat	2023-02-02
2023-01-24	TEX	Bat	2023-02-03
2023-01-24	TEX	Cat	2023-02-03

And Now I would like calculate  distinct row.
I would like recive

Bat 2 (first data exit 2023-01-14 second 2023-01-24)

Cat 2 (first data exit 2023-01-01 second 2023-01-24)

etc

In case of bat which exit is first data exit 2023-01-14 we see him in table twice time (two updates date 2023-01-01 and 2023-01-02)

I hope im clear now 

[Ashish_Mathur]

Hi,

Drag Name to the visual and write this measure

Measure = distinctcount(Data[Date])

Hope this helps.