Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!See when key Fabric features will launch and what’s already live, all in one place and always up to date. Explore the new Fabric roadmap
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.
User | Count |
---|---|
19 | |
18 | |
16 | |
13 | |
13 |
User | Count |
---|---|
10 | |
8 | |
8 | |
7 | |
6 |