Forum Discussion

arcegabriel's avatar
arcegabriel
Icon for Helper I rankHelper I
5 years ago
Solved

Problems using SELECTEDVALUE in DAX

I am having an issue using selectedvalue function from a slicer.    Table name is RegionTable Region field contains US, Canada, EMEA, APAC This table is used as a slicer   I want to assign an a...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    arcegabriel In theory something along the lines of:

    OriginitatingRegionFlag = IF(MAX('Table'[OriginatingRegion]) = SELECTEDVALUE('Table1'[OriginatingRegion]),25,10)

DestinationRegionFlag = IF(MAX('Table'[DestinationRegion]) = SELECTEDVALUE('Table1'[OriginatingRegion]),25,10)
arcegabriel's avatar
arcegabriel
Icon for Helper I rankHelper I
5 years ago

Thanks I understand but terribly lost on how to do that with measures. 

Appreciate any suggestions or a nudge on the right direction

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

arcegabriel 

could you pls provide the sample data and expected output?