Forum Discussion

ctashwin's avatar
ctashwin
Frequent Visitor
5 years ago
Solved

Visitation Counter

Hi All,   I have a Customer Table with Customer Visitation date and Customer ID. I need to setup a visitaion counter/Number for each of the Customer Visit.    I also would require the Visitaion c...
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi ctashwin ，

     

    You need a measure instead:

    Measure = 

RANKX(FILTER(ALLSELECTED('Table'),'Table'[Customer ID ]=MAX('Table'[Customer ID ])),CALCULATE(MAX('Table'[Visit Date])),,ASC)

    And you will see:

    The counter will be changed by the selection of dates.

    For the related .pbix file,pls see attached.

     

     
    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!
v-kelly-msft's avatar
v-kelly-msft
Community Support
5 years ago

Hi ctashwin ，

 

You need a measure instead:

Measure = 

RANKX(FILTER(ALLSELECTED('Table'),'Table'[Customer ID ]=MAX('Table'[Customer ID ])),CALCULATE(MAX('Table'[Visit Date])),,ASC)

And you will see:

The counter will be changed by the selection of dates.

For the related .pbix file,pls see attached.

 

 
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!