Dynamic Sum

[shubh_kush]

Hi Everyone, 

After tons of googling and RnD, finally its time to ask you guys this query 🙂

My PowerBI report has two columns say "Column_1", which has its dedicated slicer "Slicer_1" and "Column_2", which again has its dedicated slicer "Slicer_2".

Column_1 and Column_2 is Measure type and has Cost related data.

Slicer_1 and Slicer_2 has percentage data in the from of Dropdown: 5, 10, 15, 20, 25, 30.....till 95.

When I select 20 in Slicer_1, then 20% of cost in Column_1 is calculated, say the result is $55,000  

When I select 25 in Slicer_2, then 25% of cost in Column_2 is calculated, say the result is  $25,000   

Now I want to have a third column "Total_Cost", which evaluates the Total Dynamic Sum. 

That is, Total_Cost  = Column_1 + Column_2

            Total_Cost = $55,000 + $25,000 

            Total_Cost = $80,000

What I want to achieve, if user selects some other percentage in any of the slicer, the Total Dynamic Sum in Total_Cost must change.

Thanks in Advance.

Stay Safe !

[v-robertq-msft · Accepted solution]

Hi, @shubh_kush 

According to your description, you can follow my steps:

1. Create two what-if parameter for Slicer1 and Slicer2, like this:

2. Create a measure [Total_Cost]:

Total_Cost =

var _column1=[Column_1]*[Slicer1 Value]*0.01

var _column2=[Column_2]*[Slicer2 Value]*0.01

return _column1+_column2

3. Create Card visual for each measure, like this:

And you can get what you want.

You can download my test pbix file here

If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

How to Get Your Question Answered Quickly 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@shubh_kush , something like this

sum(Table[Column_1])*selectedvalue(Slicer_1[value]) + sum(Table[Column_2]) * selectedvalue(Slicer_2[value])

Assuming slicers are what if measure - https://docs.microsoft.com/en-us/power-bi/desktop-what-if