Measure tracker

Hi Anonymous 

I created a simple demo, hope it helps you . 

Original data :

Then create two measures to count the total time and task number .

Total time = CALCULATE(SUM('Table'[Time]),ALLEXCEPT('Table','Table'[User],'Table'[Week]))

Task number = CALCULATE(COUNT('Table'[Task]),ALLEXCEPT('Table','Table'[Week],'Table'[User]))

As you can see from the formula, I perform classification and aggregation operations based on column [User] and column [Week] . Of course, you can also add [day] as a column, and then sort and aggregate according to [day] .

Then you will get a table like this :

You can filter data by [User] through add column [User] in Slicer .

I have attached my pbix file , you can refer to it .

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.