Forum Discussion

PBI-Guy's avatar
PBI-Guy
Icon for Helper I rankHelper I
4 years ago

Dynamic 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...
Filters
lookup
related
relationships
VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
4 years ago

Hi PBI-Guy 

 

Can you post sample data as text and expected output? Do you want a table with Brand items and Average for each Element? 


please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
4. Relation between your tables

Appreciate your Kudos!!
LinkedIn:www.linkedin.com/in/vahid-dm/

  • PBI-Guy's avatar
    PBI-Guy
    Icon for Helper I rankHelper I
    4 years ago

    https://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.