% of grand total by maintaining filter context on column

[Dom87326]

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!

[v-yalanwu-msft · Accepted 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.