topic Re: number of visits in DAX Commands and Tips

number of visits

kuto — Fri, 17 May 2024 13:58:57 GMT

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 — Fri, 17 May 2024 15:39:05 GMT

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

kuto — Fri, 17 May 2024 16:23:02 GMT

the data in link

xifeng_L — Sat, 18 May 2024 03:53:33 GMT

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 — Sat, 18 May 2024 11:25:30 GMT