Forum Discussion

ScottWill's avatar
ScottWill
Regular Visitor
4 years ago
Solved

Create a Measure based on text in table

Hello  I need help creating a measure based on data in a table. Please see example blow  I have a table Named ModelMaster  In the table I have fields MODELCODE      VEHTYPE   Table Name: ModelMa...
Need Help
  • ScottWill's avatar
    ScottWill
    4 years ago

    I believe I figured it out 

    VEH RC ELIGABLE = SWITCH (
    SELECTEDVALUE ( ModelMaster[VEHICLETYPE]),
    "C", "Tri",
    "T", "Bi",
    "", "UNK"
    )
ScottWill's avatar
ScottWill
Regular Visitor
4 years ago

I believe I figured it out 

VEH RC ELIGABLE = SWITCH (
SELECTEDVALUE ( ModelMaster[VEHICLETYPE]),
"C", "Tri",
"T", "Bi",
"", "UNK"
)