Forum Discussion

onernoa's avatar
onernoa
New Member
4 years ago
Solved

% of Total Measure

Hello All   I would like to know the % of gr_qty to total for each article in each fiscal week ending dte.    In fiscal week ending date 09/07/2022 Site 1 recevied 5 of article 'a' All Sites re...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi

     

    Try something like this DAX measure:

     

     

    DIVIDE(
    CALCULATE(
        sum(your_table[gr_qty])
    ),
    CALCULATE(
        sum(your_table[gr_qty]),
        ALL(your_table[site])
    )
)

     

    Kind regards,
    José
    Please mark this answer as the solution if it resolves your issue.
    Appreciate your kudos! 🙂

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi

 

Try something like this DAX measure:

 

 

DIVIDE(
    CALCULATE(
        sum(your_table[gr_qty])
    ),
    CALCULATE(
        sum(your_table[gr_qty]),
        ALL(your_table[site])
    )
)

 

Kind regards,
José
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂

 

  • onernoa's avatar
    onernoa
    New Member
    4 years ago

    Thank you! I was over complicating it so much. Have a great day, José.