Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Problems with my Selectedvalue measure

Hello Community,

 

im currently struggeling with the following Selectedvalue Measure i have created:

 

Measure 2 = IF(SELECTEDVALUE('nav1029 V_VK-Umsatz Details DIENSTLEISTUNG'[Verkäufercode])="HORSTERU",SUM('nav1029 V_VK-Umsatz Details DIENSTLEISTUNG'[DB2 (MW)]),[Measure])
 
what im currently struggeling is that i want the selectedvalue to not only be Horsteru (as shown in the measure) but want to the measure to apply to two other names in the 'nav1029 V_VK-Umsatz Details DIENSTLEISTUNG'[Verkäufercode] collum. Would this be possible with the selectedvalue function ? 
 
Could you please help me with this situation as i cannot seem to solve it.
 
Thank you very much in advance.
Philip 
Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , You can try meausre like

     

    Measure 2 = IF("HORSTERU" in Values('nav1029 V_VK-Umsatz Details DIENSTLEISTUNG'[Verkäufercode])
    || "HORSTERU" in Values('nav1029 V_VK-Umsatz Details DIENSTLEISTUNG'[Verkäufercode 1])
    ,SUM('nav1029 V_VK-Umsatz Details DIENSTLEISTUNG'[DB2 (MW)]),[Measure])

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , You can try meausre like

     

    Measure 2 = IF("HORSTERU" in Values('nav1029 V_VK-Umsatz Details DIENSTLEISTUNG'[Verkäufercode])
    || "HORSTERU" in Values('nav1029 V_VK-Umsatz Details DIENSTLEISTUNG'[Verkäufercode 1])
    ,SUM('nav1029 V_VK-Umsatz Details DIENSTLEISTUNG'[DB2 (MW)]),[Measure])