March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
23 | |
16 | |
12 | |
9 | |
7 |
User | Count |
---|---|
38 | |
32 | |
28 | |
12 | |
11 |