I have a table of clients seen, broken down by quarter. As you can see the Total is unique clients but the quarters reflect unique clients in those quarters. The numbers are a distinct count of client IDs. I only want unique visitors if they weren't seen in a previous quarter. I've got the service date connected to a calendar table. I've got a slicer for the quarters.

You can use this code: Count = VAR _PrevQuarter = CALCULATETABLE ( VALUES ( Table[ClientID] ), DATEADD ( 'Calendar Table'[Date], -1, QUARTER ) ) VAR _CurrentQuarter = VALUES ( Table[ClientID] ) RETURN IF ( ISINSCOPE ( 'Calendar Table'[Quarter] ), COUNTROWS ( EXCEPT ( _CurrentQuarter, _PrevQuarter ) ), DISTINCTCOUNT ( Table[ClientID] ) ) This will provide the difference in quarters for the Quarter filter context (including the totals) and the total distincount per pooled cities on the row level and grand total. It might be worth providing an explanation to avoid false assumptions, or simply leave out the row totals altogether

Unique Clients per Quarter | Microsoft Fabric Community

Forum Discussion

Related content

lost clients by week/month/quarter

Quarter over Quarter calculation - Display Quarters missing

Calculating Quarter over Quarter Change

Quarter calculation upto selected month

Ordering Data by Quarters