Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Get column on based on multiple conditions

Hello

 

In my report I have a table which has columns "TYPE" ,"Meter Size".I have few conditions to display Type- 
 For the types which contains"TMS" then meter sizes"1,3/8,5/8"  must be displayed.For other TYPES all Meter Sizes musst be displayed.

 

 

 

Need Help
Tips and Tricks
  • _AAndrade's avatar
    _AAndrade
    2 years ago

    What you're looking for is something like this:

    I'm using this measure:

     IF(
    CONTAINSSTRING(SELECTEDVALUE(T_MeterSize[Activity Type]),"TMS"),
    "1,3/8,5/8",
    SELECTEDVALUE(T_MeterSize[Meter Size])
 )

3 Replies

  • _AAndrade's avatar
    _AAndrade
    Icon for Resident Rockstar rankResident Rockstar
    2 years ago

    What you're looking for is something like this:

    I'm using this measure:

     IF(
    CONTAINSSTRING(SELECTEDVALUE(T_MeterSize[Activity Type]),"TMS"),
    "1,3/8,5/8",
    SELECTEDVALUE(T_MeterSize[Meter Size])
 )
  • _AAndrade's avatar
    _AAndrade
    Icon for Resident Rockstar rankResident Rockstar
    2 years ago

    Hi Anonymous,

    Could you please provide more information about your issue?
    A pbix with same data would be nice if it's possible to you or pictures of your data and formulas

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      here is the report

      For the types which contains"TMS" then "TMS TYPE" having meter sizes"1,3/8,5/8"  must be displayed.For other TYPES all Meter Sizes must be displayed.