Forum Discussion

shubh_kush's avatar
shubh_kush
Helper I
5 years ago
Solved

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...
  • v-robertq-msft's avatar
    5 years ago

    Hi, shubh_kush 

    According to your description, you can follow my steps:

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

     

    1. 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

     

    1. 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.