Forum Discussion

pbiar's avatar
pbiar
New Member
3 years ago
Solved

Measure to logically display values

Hi,

I need to create a measure based on below logic on a table data.

TableName: Tst_Table

Columns: Reason, Probability

 

In the table list, 3 column should be the measure. Default is value from column Probability.

 

If User selects the list row(s), the measure value for that row(s) should get updated to 'Possible'.

 

Other unselected rows should retain the value of column 'Probability'

 

 

 

Need Help
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    Hi pbiar ,

     

    This may not be possible if you wish to select directly in the table visual.

    Please try:

    First create a new table for slicer:

    Then create a slicer:

    Apply the measure:

    Measure = IF(SELECTEDVALUE(Tst_Table[Reason]) in ALLSELECTED('For Slicer'[Reason]),"Possible",SELECTEDVALUE(Tst_Table[Probability]))

    Final output:

    Best Regards,

    Jianbo Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • v-jianboli-msft's avatar
    v-jianboli-msft
    Community Support
    3 years ago

    Hi pbiar ,

     

    This may not be possible if you wish to select directly in the table visual.

    Please try:

    First create a new table for slicer:

    Then create a slicer:

    Apply the measure:

    Measure = IF(SELECTEDVALUE(Tst_Table[Reason]) in ALLSELECTED('For Slicer'[Reason]),"Possible",SELECTEDVALUE(Tst_Table[Probability]))

    Final output:

    Best Regards,

    Jianbo Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.