Forum Discussion
shubh_kush
5 years agoHelper I
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 "Colu...
- 5 years ago
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.
amitchandak
5 years agoSuper User
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