Return Multiple Values in a Matrix Visual as Values

[COIL-ibesmond]

Hello,

I'm trying to figure out how to add purchase details to an inventory summary. I can't attach a pbix, but I'll try to provide all the details I can.

I would like to have the values side by side, but I would be open to a tooltip that displays the values if what I am trying to do is not possible.

Here is an example of my data model.

Here is an example of the matrix in the visualization pane.

I tried pulling in the PO Number directly and my options are aggregated.

First, Last, Count (Distinct), Count, which is not what I want.

I have tried a number of things but cannot find a solution.

This is the current result.

This is the desired result

As you can see, the result produces each invididual PO and details associated with it.  

The alternative would be to create a tooltip visual to show the purchases:

Thanks.

[COIL-ibesmond]

Hi @Daniel29195,

Thanks for the fast reply. Unfortunately that doesn't seem to work for my situation.  My later columns, sum(qty) and sum(cost) do not respond.  They remain aggreagated as one value for each. I don't want to change to text either because I use them for other calculations.  

Also my other measure Vendor ID* does not respond either.  I have a situation where one vendor ID is blank and the other is not, and it mismatches the line associating it with the first PO when it is associated with the second PO.

Vendor ID* =

CALCULATE(

    CONCATENATEX( VALUES( dim_Vendor[Vendor ID] ), dim_Vendor[Vendor ID], UNICHAR(10) ),

        CROSSFILTER(fact_Purchases[Vend_Key], dim_Vendor[Vend_Key], Both ) )

[Daniel29195]

@COIL-ibesmond 

use the concatenatex function . 

this is the pattern : 

concatenatex ( values(tbl_name[col_name] ) , tbl_name[col_name] , unichar(10) ) 

unichar (10 ) ==  line break . 

let me know if this helps .

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🙏