I have a pivot table with column called Product Category and row called EE Segment. I have created a measure that counts # of Clients by using: count(distinct([Client ID])). This measure gives me # of clients in each Product Category by EE Segment. I also have totals by EE Segment in Pivot table. Now I want to create a measure in the pivot table where I can get % for each Product. i.e #of clients in each Product Category by EE segment/total clients in each EE segment.
Please see attached picture of the pivot table.
I would appreciate if I can get ideas of how to create the measure
