Finding issue to get common id's between two years and calculate the count using p()

[April1234]

I am trying to find the count of common id's from two years using P(), but it shows issue with the calculation

using the calculation like this ,Count({<ID=p({<year={'2022'}>})>*p({<year={'2023'}>})>}distinct ID)

But issue here is , it shows increase in values initially in a table with all the locations specified but shows correctly when a particular location is selected.

Any help here to fix the logic to show same numbers with or without selection of location?

Thank you!

[MatheusC · Accepted solution]

@April1234 
try this:

Count({<year={'2022'},ID=P({<year={'2023'}>}ID)>}distinct ID)

Regarts, Matheus 

[April1234]

It is very close to the numbers . I gave a try swapping the numbers and it worked. 

Count({<year={'2023'},ID=P({<year={'2022'}>}ID)>}distinct ID)   

 Thank you so much Matheus for the logic.