Is it possible to have a dynamic column based off a slicer/filter?

[Anonymous]

I am trying to create a dynamic column that will reflect a percent change from a total amount. I would like to be able choose a percent change of "Total Charge" from the slicer on the left that would then reflect in the data columns on the right.

Is it possible to have one column (to the right of "Total Charge") that could change based off of my slicer to show the percent change of the "Total Charge" value? I have already created measures in this table that do this calculation, but would like only one measure to show up at a time based off of the slicer selection. 

[MFelix · Accepted solution]

Hi @Anonymous ,

I assume that the % is a table that you have correct?

You need to add the percentage values to that table it has to look something like this:

  %              Category

-0,1	10% Decrease
0,1	10% Increase
-0,25	25% Decrease
0,25	25% Increase
-0,05	5% Decrease
0,05	5% Increase
0	Baseline

Then add the following two measures:

Selected % = SELECTEDVALUE(Percentages[%])



Total adjusted =
IF (
    COUNT ( Percentages[%] ) > 1;
    "Need to select only one percentage value";
    SUM ( Revenue[Total Charge] ) * ( 1 + [Selected %] )
)

Then add this measure to your table, check the result on the PBIX file attach.

Regards,

MFelix

[Anonymous]

This is exactly what I was looking for. Thank you!