Custom Static columns in Matrix Table

[hasarinfareeth]

Hi 

I am tryng to add a customer static column in a Matrix table visual where I have count of tickets closed for each month in a specific function. 

Below is my Matrix table where description is the function and the numbers are the count of the tickets closed for each month. I wanted to add a statis column against each description mentioning if it is automated or not. This status column is a text column where I can provide if the updates on the automation if not completed. 

Note - the static column is available in the same table where I have the description details as a master data. 

Can anyone help me, please?

[Anonymous · Accepted solution]

Hi, @hasarinfareeth 

Based on your description, I've created this example data:

First, create a header table that will contain the columns in your matrix:

After that, create the relationship as follows:

Then establish the following measure:

Measure = 
VAR _index = SELECTEDVALUE('Header Table'[Index])
RETURN SWITCH(TRUE(),
    _index=1,CALCULATE(MAX('Table'[static])),
    CALCULATE(SUM('Table'[SalesAmount]),USERELATIONSHIP('Header Table'[Type],'Date Table'[Year-Month]))
)

As a result, you were able to correctly add a static column to the matrix:

Best Regards

Jianpeng Li

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

[Anonymous]

Hi, @hasarinfareeth 

I wish you all the best. Previously we have provided a solution to help you solve the problem. Since we haven't heard back from you yet, I'd like to confirm if you've successfully resolved this issue or if you need further help?
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.

Best Regards

Jianpeng Li

[Anonymous]

Hi, @hasarinfareeth 

Add a separate column to the matrix, which in Power BI can be achieved by customizing the matrix layout.
By defining a table of matrix columns, the corresponding values are returned by using the DAX function judgment.
I found a detailed blog in the community to explain this matter, and it is worth your reference and use in your example:

Creating a “custom” or “hybrid” matrix in PowerBI - Microsoft Fabric Community

Alternatively, you can follow the practice in the following two cases.

Solved: How to show a Row Total as Row element in a matrix... - Microsoft Fabric Community

Solved: How to add a custom measure at the end of matrix v... - Microsoft Fabric Community

Best Regards

Jianpeng Li

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