number of visits

[kuto]

Hi 

need help to calculate:

-number of visits per ID per department during period (count distinct id once per day, exclude duplicate).

the result of measures:

number of customers who visits 4 time during period =1 (ID 123)

number of customers who visits 3 time during period =1

if no custome have 4 visit the result 0

[xifeng_L · Accepted solution]

Hi @kuto ,

You can try below measure.

Number of customer with 4 visits during period = COUNTROWS(FILTER(ALL('Table'[Id]),CALCULATE(DISTINCTCOUNT('Table'[Date ]))>=4))

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~

[ThxAlot · Accepted solution]

[kuto]

https://docs.google.com/spreadsheets/d/1pGNYR-KwpqLKNHOYG-1Apm3YI_nlN0js/edit?usp=sharing&ouid=10303... 

the data in link 

[xifeng_L · Accepted solution]

Hi @kuto ,

You can try below measure.

Number of customer with 4 visits during period = COUNTROWS(FILTER(ALL('Table'[Id]),CALCULATE(DISTINCTCOUNT('Table'[Date ]))>=4))

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~

[xifeng_L]

Can you provide some example data or pbix files? Can't copy the data from the screenshot. And, what is you expected result?