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.
Hello,
I have the followinf fact table:
Question | RespondentId | Answer | % of GT of RespondentId |
What's your name | 39 | Dana | 9% |
What's your name | 69 | Juliet | 9% |
What's your name | 71 | Lorelai | 9% |
What's your name | 31 | Caden | 9% |
What's your name | 57 | Imani | 9% |
What's your name | 38 | Adrien | 18% |
What's your name | 68 | Valentin | 18% |
What's your name | 81 | Dale | 36% |
What's your name | 53 | Dale | 36% |
What's your name | 16 | Dale | 36% |
What's your name | 64 | Dale | 36% |
What's your favorite city | 39 | Lora del Río | 9% |
What's your favorite city | 69 | Marchena | 9% |
What's your favorite city | 71 | Moron de la Frontera | 9% |
What's your favorite city | 31 | Barcelona | 9% |
What's your favorite city | 57 | Madrid | 9% |
What's your favorite city | 38 | Did not answer | 18% |
What's your favorite city | 68 | Did not answer | 18% |
What's your favorite city | 81 | Huesca | 36% |
What's your favorite city | 53 | Huesca | 36% |
What's your favorite city | 16 | Huesca | 36% |
What's your favorite city | 64 | Huesca | 36% |
Now I want to add a custom column [% of GT of RespondentId], however I need that to take into account Question value.
In a report view I use a table that shows [Answers] and Count of [RespondentId], as well as [% of GT of RespondentId], in addition to using Filter's pane on the whole page for [Question]. Every page shows different questions and thus has an active page level filter.
Thanks for help!
Solved! Go to Solution.
Hi, @Dom87326 ;
I don't quite understand your logic, how did you calculate % of GT of RespondentId? What kind of logic implements this formula for 9% and 18% and 36%?
I tested it as follows:
so can you share more information or your logic?
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Dom87326 ;
I don't quite understand your logic, how did you calculate % of GT of RespondentId? What kind of logic implements this formula for 9% and 18% and 36%?
I tested it as follows:
so can you share more information or your logic?
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
45 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
73 | |
50 | |
45 | |
20 | |
17 |