Using a slicer to change revenue dynamically within a measure

[xxjq88]

Hi guys,

I want to know if it is possible to have a value measure where it will essentially be "Measure = Divide([Salary],[Revenue],0)"

But I want to be able to change the Revenue #'s dynamically?

For example, Revenue = Income A + Income B.

I want to be able use a slicer or something similar, where I can click on "Income A" and the graph will change to show Salary/Income A and if i press Income B it will be Salary/Income B.

Currently I have 2 separate graphs. I want to know if it's possible to just put it into one graph. 

Thank you. 

[quentin_vigne · Accepted solution]

Hi @xxjq88

I've done something similar using this tutorial : http://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Measures-Titles-Using-SWITCH/td-p/200...

Use switch function so that your graph display the measure wanted

It takes a little bit of time but It's worth it

- Quentin

[xxjq88]

Hi Quentin,

Just need a little bit of help. 

I've created the following measure:

"SelectedMeasure = IF(HASONEVALUE(IncomeMeasureTbl[MeasureName]),SWITCH(VALUES(IncomeMeasureTbl[MeasureName]),"Teaching Income",DIVIDE([ExpTotalSalary],[RevTeachingIncome],0),"Other Income",DIVIDE([ExpTotalSalary],[RevOtherIncome],0)))"

and created the table to store the names - "Teaching Income" & "Other Income".

But it doesn't seem to work. 

Any tips?

Thank you in advance

[xxjq88]

nevermind. i figured it out. thanks for your help!

[xxjq88]

Hi Quentin, thank you for the tutorial. I'll give this a try!

[Hardik]

You can do this using a treemap