Forum Discussion

Julia2023's avatar
Julia2023
Helper I
1 year ago

Ideas for Measure

Hi everyone, I'm looking for some ideas. I have a measure called "Position," and I need to create a measure called "GOAL" (which should be the sum of "Position" but with a total of 100%). The current...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Julia2023 ,
You can calculate the total sum of the "Position" measure. And then Divide each "Position" value by the total sum to get the percentage.

TotalPosition = 
    CALCULATE(
        SUM('YourTable'[Position]),
        REMOVEFILTERS('YourTable')
    )
GOAL = 
DIVIDE(
    SUM('YourTable'[Position]),
    TotalPosition,
    0
)

 

Best regards,
Albert He

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