Forum Discussion

powerbiuser444's avatar
powerbiuser444
Icon for Helper I rankHelper I
5 years ago
Solved

How to add a calculated column to a matrix

Hi, I know there is a similar topic in the thread but I couldn't achieve what I wanted following the solution (maybe because my data model is different). Basically what I need is to divide one colum...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi powerbiuser444 ,

     

    Please refer to my .pbix file.

     

    In addition, I used the "Sort by column" feature in the calculation table below.

     

    Best regards,
    Lionel Chen

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

     

v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi powerbiuser444 ,

 

Please refer to my .pbix file.

 

In addition, I used the "Sort by column" feature in the calculation table below.

 

Best regards,
Lionel Chen

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

 

powerbiuser444's avatar
powerbiuser444
Icon for Helper I rankHelper I
5 years ago

Hi v-lionel-msft thanks for your time. Unfortunately, when I add slicers for Campaign and Agents, your measure doesn't recalculate. The numbers for SPH and Target vs Actual are static. Is it possible to modify the measures so the numbers are recalculated based on what Campaign and Agent selected?