Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

% Measure Query

Hi All, I hope everyone is doing well and thanks in advance, with any assistance provided with my query " PS Apologies in advance if this is not the correct section of the forum " I'm creating ...
  • az38's avatar
    az38
    6 years ago

    Hi Anonymous 

    try a measure like

    Measure = DIVIDE(
CALCULATE( SUM('Table'[Waste]), ALLEXCEPT('Table', 'Table'[Type]) ),
CALCULATE( SUM('Table'[Waste]), ALL('Table') )
)

     

    do not hesitate to give a kudo to useful posts and mark solutions as solution

az38's avatar
az38
Community Champion
6 years ago

Hi Anonymous 

try a measure like

Measure = DIVIDE(
CALCULATE( SUM('Table'[Waste]), ALLEXCEPT('Table', 'Table'[Type]) ),
CALCULATE( SUM('Table'[Waste]), ALL('Table') )
)

 

do not hesitate to give a kudo to useful posts and mark solutions as solution

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Az38,


Thanks for the reply, that worked, after using the mesaure I had to set the filter !!! ðŸ˜‚

 

Cheers