Summary table with columns grouped by existing filters.

[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. 

Thanks!

[Anonymous]

Hi @Anonymous ,

The pbix link you provided is temporarily inaccessible, please check and re-upload.

Best Regards,
Adamk Kong

[Anonymous]

Re-uploaded: SALEScopy.pbix

[Anonymous]

Hi @Anonymous 

Still error.☹️

Best Regards,
Adamk Kong

[Anonymous]

I tried sharing this with someone else, he was able to access it. Can you look into this thread : https://community.fabric.microsoft.com/t5/Desktop/Table-with-columns-grouped-by-slicer-values/m-p/36...
I have started this thread, as I had problems in replying in this thread, and I believe someone else was able to access it there. Please close this thread.
Thanks!

[Anonymous]

Hi, I have re-uploaded the file here.