Forum Discussion

mm306's avatar
mm306
Regular Visitor
6 years ago

Using slicer data as result to if else statement

I have the following table. I wish for the Cost values to be provided by the slicer output, whereby each cateogy has a cost slicer that a user can select the value from. Is there a way to do so?   ...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

mm306 , that should come by default when you filter using slicer. What is expected outcome?

mm306's avatar
mm306
Regular Visitor
6 years ago

 

Cost = if (Table1[Category]="High",[cost_high],if(Table1[Category]="Medium",[cost_medium],if(Table1[Category]="Low",[cost_low])))

 

And the output for column Cost above is BLANK.

 

Is there a way for the Cost to reflect the slicer output?

 

Thanks.

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    6 years ago

    mm306 

     

    Values in a calculated column are fixed. You'll need to create a measure instead.

     

    • mm306's avatar
      mm306
      Regular Visitor
      6 years ago

      Thanks for the replies.

      May I have some example please, on how to create the measure?