Forum Discussion

TheCAKurtle's avatar
TheCAKurtle
Helper I
6 years ago
Solved

Dynamic Budgeting Tool

I am currently trying to build a dynamic budgeting tool for an energy company. With oil prices being so low currently this company would like to have the ability to "turn off" a well to help determin...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi TheCAKurtle ，

     

    1. Create a slicer table,put the categories in the column:

     

    2.Delete the relationship between table and the slicer table:

     

    3.Create a measure as below:

     

    Measure = IF(SELECTEDVALUE('slicer table'[category])=SELECTEDVALUE('Table'[Category]),0,'Table'[Ratio])

     

    Finally you will see:

     

    Is the above what you need?

     

    Here is my sample .pbix file you can refer to.

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!