% of Total Measure

Question

Hello All&nbsp;I would like to know the % of gr_qty to total for each article in each fiscal week ending dte.&nbsp;&nbsp;In fiscal week ending date 09/07/2022Site 1 recevied 5 of article 'a'All Sites received 14 (5 + 7 + 2) of article 'a'I would like a column that calculates (5 /14) for row 1, (7/14) for row 2, (2/14) for row 3, (6/19) for row 4 and so on.&nbsp;sitefiscal_week_ending_dtearticlegr_qty109/07/2022a5209/07/2022a7309/07/2022a2109/07/2022b6209/07/2022b5309/07/2022b8102/07/2022a4202/07/2022a4302/07/2022a7102/07/2022b7202/07/2022b5302/07/2022b7&nbsp;Thanks in advance!onernoa&nbsp;

anonymous · Accepted Answer

Hi&nbsp;Try something like this DAX measure:&nbsp;&nbsp;DIVIDE(
    CALCULATE(
        sum(your_table[gr_qty])
    ),
    CALCULATE(
        sum(your_table[gr_qty]),
        ALL(your_table[site])
    )
)&nbsp;Kind regards,JoséPlease mark this answer as the solution if it resolves your issue.Appreciate your kudos! 🙂&nbsp;

Forum Discussion

% of Total Measure

2 Replies

Related content

% of total measure

Total of Measure

Measure Total Incorrect

Measure Total, again

Adjust this measure to show totals

site	fiscal_week_ending_dte	article	gr_qty
1	09/07/2022	a	5
2	09/07/2022	a	7
3	09/07/2022	a	2
1	09/07/2022	b	6
2	09/07/2022	b	5
3	09/07/2022	b	8
1	02/07/2022	a	4
2	02/07/2022	a	4
3	02/07/2022	a	7
1	02/07/2022	b	7
2	02/07/2022	b	5
3	02/07/2022	b	7