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
danextian's avatar
danextian
Super User
1 year ago

Hi Julia2023 

 

This measure below creates  a virtual summary table by product id containing a column called @position which returns a value if [goal] is equal to 1.

SUMX (
    ADDCOLUMNS (
        SUMMARIZE ( 'table', 'table'[product id] ),
        "@position", IF ( [goal] = 1, [position] )
    ),
    [@position]
)