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

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
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, this worked well for me (had to make some adjustments to align with my model). Appreciate it