Forum Discussion

ddpl's avatar
ddpl
Solution Sage
3 years ago
Solved

Calculate Count...

Data...   Client ID Date A1 01-Aug-22 A2 02-Aug-22 A2 03-Aug-22 A3 04-Aug-22 A3 05-Aug-22 A3 06-Aug-22 A4 07-Aug-22 A4 08-Aug-22 A4 09-Aug-22 A4 10-Aug-2...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi ddpl ,

     

    I think you can try this code to create a measure.

    Count =
IF (
    MAX ( 'Table'[Date] ) >= DATE ( 2022, 08, 10 ),
    CALCULATE (
        COUNTROWS ( 'Table' ),
        FILTER (
            ALLEXCEPT ( 'Table', 'Table'[Client ID] ),
            'Table'[Date] >= DATE ( 2022, 08, 10 )
        )
    )
)

    Result is as below.

     

    Best Regards,
    Rico Zhou

     

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

     

amitchandak's avatar
amitchandak
Super User
3 years ago

ddpl , Use an after date slicer, Create a date table and join that with your table and create measure like

 

calculate(countrows(Table), allselected(Date))

 

or with selected date as 10th

 

calculate(countrows(Table), filter(all(Date), date[Date] >= maxx(allselected(Date) , date[Date]) ) )