Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DAX Formula | Selects Other Measure based on Value

  Hi, I'm quite new to MS Power BI - Tools, so sorry in case I didn't pick exactly the right subject/location.   Following issue I can't get to work: - I created two measures in Power Pivot (ACT_...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, Anonymous 

    sorry, there is a mistake when post the formula, try this

    ACT_%_NEW:=IF(MAX('HIERARCHY'[GROSS_NET])=1 , [ACT_GROSS_%] , [ACT_NET_%])

    Best Regards,
    Lin

v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

hi, Anonymous 

Just use MAX instead of selectedvalue 

ACT_%_NEW:=IF(MAX('HIERARCHY'[GROSS_NET]=1) , [ACT_GROSS_%] , [ACT_NET_%])

Best Regards,

Lin

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Lin, getting a semantic error, that MAX only accepts a column reference as an argument

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    7 years ago

    hi, Anonymous 

    sorry, there is a mistake when post the formula, try this

    ACT_%_NEW:=IF(MAX('HIERARCHY'[GROSS_NET])=1 , [ACT_GROSS_%] , [ACT_NET_%])

    Best Regards,
    Lin