I am trying to total the duration of an appointment for a user by date. In the below table, I want to see 5 rows one per date. I am able to get totals, but it is for all users not per user. Any thoughts?
Hi @kingchad5,
You can create a measure like below:
Measure = CALCULATE(SUM('Table1'[duration_hours]),FILTER(ALL('Table1'),'Table1'[full_name]=MAX('Table1'[full_name]) && 'Table1'[date_only]=MAX('Table1'[date_only])))
Best Regards,
Qiuyun Yu
Hi @kingchad5,
You can create a measure like below:
Measure = CALCULATE(SUM('Table1'[duration_hours]),FILTER(ALL('Table1'),'Table1'[full_name]=MAX('Table1'[full_name]) && 'Table1'[date_only]=MAX('Table1'[date_only])))
Best Regards,
Qiuyun Yu
Helpful resources
Join our Fabric User Panel
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Power BI Community Update - March 2026
Check out the March 2026 Power BI update to learn about new features.
