Percentage of Sub total

[klod78]

Hi, I am making a report for a survey which is submitted every two months, as per picture below, I have i.e. the results of a first round of the survey in June and the results of a second round in July. the answers of the question can be Strongly agree, agree, neutral, disagree and strongly disagree and I need to show the values as % of the June answers in a stacked column chart, the % of July answers in the same stacked column chart, but in a different bar and so on.....I am aware that I can show the values of the grand total, but in this way every survey round I will have more answers so the grand total increase and the % of June, July and so on changes...I need to freeze June, July answers and so on in the same stacked column chart in different bars and each bar has to be linked to the total of the answers for that month only...can you help me? 

[v-deddai1-msft · Accepted solution]

Hi @klod78 ,

Use measure like：

% of Grand Total =
DIVIDE (
    Count ( Table[select an answer] ),
    CALCULATE ( Table[select an answer], ALLEXCEPT ( 'Table',Table[Start time] ) )
)

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[amitchandak]

@klod78 , refer if this can help

https://community.powerbi.com/t5/Desktop/Percentage-of-subtotal/td-p/95390