Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
32 | |
15 | |
14 | |
13 | |
9 |