Forum Discussion

fridge81's avatar
fridge81
New Member
8 years ago
Solved

Dynamic Column calculation based on Slicer Selection

HI,   I'm relatively new to PowerBI and have run into some trouble calculating a percentage in a way that the calculation updates depending on what filters are applied.  I have a scaled down exampl...
  • v-sihou-msft's avatar
    v-sihou-msft
    8 years ago

    fridge81

     

    In this scenario, you already have Product Size (Small, Medium, Large) and Industry Classification (1,2,3) column in your table, you just need one Market Size column instead of splitting into multiple columns that one for each "combo". 

     

    Just re-modeling your table to keep only on Market Size column. Since you need the Revenue and Market Size values take the filter, you should create measures for Revenue and Market Size for your calculation, and put measure instead of column into visual. 

     

    Regards,

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

fridge81

 

In this scenario, you already have Product Size (Small, Medium, Large) and Industry Classification (1,2,3) column in your table, you just need one Market Size column instead of splitting into multiple columns that one for each "combo". 

 

Just re-modeling your table to keep only on Market Size column. Since you need the Revenue and Market Size values take the filter, you should create measures for Revenue and Market Size for your calculation, and put measure instead of column into visual. 

 

Regards,