cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
powerbiuser444
Helper I
Helper I

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 column by another in the matrix (actual vs target).

 

Please click the link to the pbix file 

and the picture of the matrix itself that I want to achieve.Matrix.jpg

Really appreciate your help!

 

1 ACCEPTED SOLUTION
v-lionel-msft
Community Support
Community Support

Hi @powerbiuser444 ,

 

Please refer to my .pbix file.

 

v-lionel-msft_1-1622442918489.png

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

v-lionel-msft_2-1622442932751.png

 

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.

 

View solution in original post

3 REPLIES 3
v-lionel-msft
Community Support
Community Support

Hi @powerbiuser444 ,

 

Please refer to my .pbix file.

 

v-lionel-msft_1-1622442918489.png

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

v-lionel-msft_2-1622442932751.png

 

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.

 

View solution in original post

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?

gboppana
New Member

Unfortunately, with the data model you have, it is not posisble to insert the calculated column the way you want.  Suggest to insert the Traget vs ACtual values in the dataset itself (i.e. calcluate in the source itself). Hope this helps.

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!