Forum Discussion

Helper V

6 years ago

Solved

% share for week

Hi,
I need a advice. How I create % share for week?

Thank you
Ondřej

Anonymous

Try to use the below measure:

Measure 10 = DIVIDE(CALCULATE(SUM('Table (3)'[QTY])),CALCULATE(SUM('Table (3)'[QTY]),ALL('Table (3)'[Haulier])),0)

Aiolos Zhao

Anonymous

Not applicable

Try to use the below measure:

Measure 10 = DIVIDE(CALCULATE(SUM('Table (3)'[QTY])),CALCULATE(SUM('Table (3)'[QTY]),ALL('Table (3)'[Haulier])),0)

Aiolos Zhao