Add new columns separately yo Matrix Table

[damit23183]

Hi,

I am trying to add new columns into the MATRIX table below;

This is the table i do have currently;

This is all working fine, now i want to add several new columns to this Matrix. Please see below what i am looking for; (For Example 2 columns below but there 7-10 columns i will add)

As you can see above "Number of Settlement" and "Number of Warning" are totally speparate Columns which has nothing to do with ROW and COLUMN headers (Left Side).

I am looking for count of certain cases based on different scenario.

Any suggestion would be appreciated

I tried with MATRIX and ACETRYS MATRIX LIGHT tables but its not working because whenever I add new columns it usually come inside column header which i dont want. New column must be seperate.

Thanks

[carib123456]

Hello,

I have the same exact issue, and the sample was not much help. Has there been an update on this response?

-Jorge

[parry2k]

@damit23183 there is a workaround for this, see attached and you will get an idea, look at the matrix with the blue background, you need to apply the similar logic.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

[Em3dream123]

I still have unresolved problems,

im trying with your file but idk why it cant visual , how to do that, pls guide me! thanks you.

[damit23183]

Hi,

Yes I went through it which i already have that is total of each row but, I would like to add new columns which has nothing to do with current and lastyear values. If you take your example then ALL Total / Grand Total column is sum of rows and columns value.

If you take your example then I would like to add two new columns into the existing Matrix; 

1) No of products where date is not Null = NOPWON

2) No of Products where date is null = NOPWN

This is just an example;

Your example should look like below; this is an example from EXCEL but this is what i am looking for.

Thanks

[parry2k]

@damit23183 idea is in the solution I pasted, you have to tweak it as per your needs, you can control whatever you want.

[damit23183]

Hi,

Thanks for quick turn around.

My apologies, didn't look at Measure that you have created with variable. 

Thought to be direct solution but i will look into that MEASURE and see how it work. 

Thanks a lot for your suggestion.

Thanks

[parry2k]

@damit23183  as I mentioned, it is not out of the box, you have to create workaround as shown in shared in pbix. good luck.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!