Forum Discussion

fpennisi17's avatar
fpennisi17
Icon for Helper III rankHelper 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...
  • CNENFRNL's avatar
    CNENFRNL
    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] ) )
)

     

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

fpennisi17 

Create two measure and add to a matrix;

 

Count = SUM(Table1[Samples])
----------------------------------------------------
Percent = 
DIVIDE(
    [Count],
    CALCULATE(
        [Count],
        ALLSELECTED(Table1[State])
    )
)

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn