Forum Discussion
PBI-Guy
Helper I
Helper IDynamic filtering for related sub data
Here goes...this is my first post on the forum so please forgive any missed etiquette. I hope I can explain this as best as humanly possible. Goal: Multi-Category Filters in table 1 are reflected...
PBI-GuyHelper I
Helper Ihttps://1drv.ms/u/s!Ap_eXUht9lqhhT4VlI7mT6vHYeme?e=ZBN9dl
Please see attached one drive link to the pbix file. I want to be able to summarize the brand dynamically so that when I filter on the survey questions I gives me the proper aggregated averages for the elements 1 -3 in the 02Profile_Calculated table which feeds back into the 01MergeDataSet which is the table that drives my visuals and filters. I hope this makes sense because I do have a hard time explaining it but if you need more I will do what I can.
Cheers
Sean