Forum Discussion

Helper III

5 years ago

Solved

Calculate frequency by sample type

Hi, I have a table similar to the following one: Asset State Type Samples AAAAA 0 X 1000 AAAAA 1 X 200 AAAAA 2 X 300 AAAAA 3 X 50 AAAAA 0 Y 500 A...

5 years ago

Hi, fpennisi17 , you might want to try this measure,

% Type =
DIVIDE (
    MAX ( 'Table'[Samples] ),
    CALCULATE ( SUM ( 'Table'[Samples] ), ALLEXCEPT ( 'Table', 'Table'[Type] ) )
)

Community Champion

5 years ago

Hi, fpennisi17 , you might want to try this measure,

% Type =
DIVIDE (
    MAX ( 'Table'[Samples] ),
    CALCULATE ( SUM ( 'Table'[Samples] ), ALLEXCEPT ( 'Table', 'Table'[Type] ) )
)

Helper III

5 years ago

Great!

Thank you!