Hello, I am working on a pivot table that summarizes accounts of clients and client ID's by brackets of available balances, i.e. accounts with balances less than $3,000 are grouped together, accounts with balances between $3000 and $10,000 are grouped together,etc. The main Data table I have, lists the accounts of all clients, their respective balances, and the respective client ID's (each ID might have several accounts). I manually created a table which has two columns: "Brackets Column" and "Bracket Code". I added a calculated column named "Bracket Code" to the Data Table and created a relationship between both tables using the aforementioned calculated column. Currently I am using pivot table to summarize the number of distinct account numbers and distinct client ID's under each category. Pivot table will have the following columns: Column 1 Column2 Column3 "Bracket Category" count of distinct account numbers count of distinct ID's Column2 is being calculated easily by creating the measure= Count(Distinct(Account Numbers)) However, for client ID's it isn't that simple. When am using the same measure for ID's, the same ID is counted under more than one Bracket Category. Could anyone help on the syntax of the measure which would count each ID once under its designated "Bracket Category" Thanks
