Add formula from a list of column in a table or table matrix

[Anonymous]

I have a list of task that should be percentage value should be distributed equaly and 1 task which is a NTTP is calculate differently if the total percentage is >100% then 0% should reflect to maintain the rest to 100% but whenever I calculate it, it just evenly distribute the %total to each task and when sum it is over 100% (Task + NTTP value)

This is what I have now

This is what I'm trying to 

Thanks in advance

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please refer to my pbix file to see if it helps you.

Create a measure.

Measure =
VAR _sum =
    CALCULATE (
        SUM ( 'Table'[NT_MAIN%_Acnt] ),
        FILTER ( ALL ( 'Table' ), 'Table'[Category_Grp] <> "NTTP" )
    )
VAR _SUMALL =
    SUMX ( ALL ( 'Table' ), 'Table'[NT_MAIN%_Acnt] )
VAR RESULT_ = 1 - _sum
VAR _IF =
    IF (
        MAX ( 'Table'[Category_Grp] ) = "NTTP"
            && _SUMALL > 1,
        RESULT_,
        MAX ( 'Table'[NT_MAIN%_Acnt] )
    )
RETURN
    _IF

I have also create the formula in the column.

If I have misunderstood your meaning, please provide your pbix file without privacy information and desired output.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.