Forum Discussion
Dynamic Sum
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 !
Hi, shubh_kush
According to your description, you can follow my steps:
- Create two what-if parameter for Slicer1 and Slicer2, like this:
- 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- 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.
2 Replies
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
Hi, shubh_kush
According to your description, you can follow my steps:
- Create two what-if parameter for Slicer1 and Slicer2, like this:
- 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- 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.
