Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 in the aggregated summary average for the same category in table 2.
Step 1:
I literally do not have the mental know-how ohn how to achieve this and I have been trying for the last 6 days and am just about ready to give up so any assistance you can provide would be greatly appreciated.
Thanks,
Sean
Hi, @PBI-Guy
Slicers have no effect on the generated calculated table.
You may need to calculate the value in temporary table (measure).
Best Regards,
Community Support Team _ Eason
@v-easonf-msft that's what I thought but I don't know how to do that. Any insight you can provide will be helpful and greatly appreciated
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.
Cheers
Sean
@VahidDM thanks so much for the follow-up...I will prep a sample file with the pbix file.
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/
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
19 | |
19 | |
16 | |
15 |
User | Count |
---|---|
49 | |
26 | |
22 | |
17 | |
16 |