Table with columns grouped by slicer values.

[Anonymous]

Hi, I have page 1 with all my visualization, and page 2 would summarize all these in a tabular form. I'm trying to add some columns grouped by the filters 'State' and 'Customer Segmentation' for the 'Average of PRODPERVISIT' column into the table for more insights. So I want 2 more columns  'Average of PRODPERVISIT (State)' - which gives the average in-state level and 'Average of PRODPERVISIT (Customer Segment)' - which would provide an average in  customer segment.

Please find the pbix file here: SALEScopy.pbix 

Thanks!

[vanessafvg]

not  quite clear what you are looking for, can you give an example of what you are looking for 

ie  when you usay average by state or segement what does that look like practically