Matrix Visualization - displaying fields in expanded view without grouping or summarizing by them?

Hi PaulKraemer ,

For this I would create  two additional metrics to add to the values and would do it based on the level you are so something similar to:

Date Value = IF(ISINSCOPE(Ticket[Number]), SELECTEDVALUE(Ticket[Date]))

Description Value = IF(ISINSCOPE(Ticket[Number]), SELECTEDVALUE(Ticket[Description]))

This will give you the values only at the level of the number.

Hi PaulKraemer 

Thank you very much MFelix for your prompt reply.

May I ask if your problem has been solved? If not, let me add some details.

Create measures:

Use the code provided by MFelix.

Returns true when the specified column is the level in a hierarchy of levels.

ISINSCOPE function (DAX) - DAX | Microsoft Learn

Returns TicketDate and Description when at the “Number” level, otherwise returns blank.

The created measures are then put into the “Values” of the matrix. Please note that measures can only be placed into “Values” of the matrix, not into “Columns” or “Rows”.

Regards,

Nono Chen

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