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!
v-kelly-msft's avatar
v-kelly-msft
Community Support
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!