Create Matrix chart from table chart

[jie]

Hi all,

I need your help with this problem.

I create a table chart with selected value using selectedvalue function. For example, I have a filter with distincts time zones, when I clic in some of then, the column STimeZone of my table is upload.

 

My question is, I want to create a matrix table with resumen of How many trainers (count traineeId) by equipment and StimeZone I have?

Plz, I need your help.

[MFelix]

Hi @jie ,

If you create a matrix with the following setup you will get what you need:

• Rows:
  • StimeZone
  • Equipment
• Columns
  • Can be empty or with one of the above columns has you prefer
• Values
  • TraineeID (aggregation count)

That should give expected result.

[jie]

Thank u for your answer Miguel.

The problem is that STimeZone is a measure. So, I can't use this for matrix. 😞

[v-kelly-msft · Accepted solution]

Hi  @jie ,

Create a dim table using all the measure values as the column values,such as below:

Then create a measure to get what you need:

Measure =
SWITCH (
    SELECTEDVALUE ( dim[Stimezone] ),
    "Othertimezone",
        CALCULATE (
            SUM ( 'Table'[Value] ),
            FILTER ( 'Table', 'Table'[Stimezone] = "Othertimezone" )
        ),
    "Sametimezone",
        CALCULATE (
            SUM ( 'Table'[Value] ),
            FILTER ( 'Table', 'Table'[Stimezone] = "Sametimezone" )
        )
)

I made a simple sample for reference,pls check attached.

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

[MFelix]

Do you need to show the timezone on the matrix?

You can create the matrix has I explained but without the measure. Then place the measure has a card to serve has title or similar.

If you can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.