Line/measure with multiple values

[marcos_osorio]

Hi, I have a table with several product sizes, the products have too 4 or more different brands. 

So I want to show it in a matrix in this way:

PRODUCT      QTTY  %SHARE   FOCUS

A                    10       5%            BrandA(45%),BrandB(20%),BrandC(35%)

B                     20      10%           BrandA(1%),BrandC(40%),BrandD(59%)

Is there a way to make the Colum "FOCUS" as I put it like in a measure?

Thank you very much.

[v-cherch-msft · Accepted solution]

Hi @marcos_osorio 

You may create the columns as below and then get the Focus measure.For example:

%Brand =
CALCULATE ( COUNT ( TB[Brand] ), ALLEXCEPT ( TB, TB[Product], TB[Brand] ) )
    / CALCULATE ( COUNT ( TB[Product] ), ALLEXCEPT ( TB, TB[Product] ) )

Column = TB[Brand]&"("&FORMAT(TB[%Brand],"0%")&")"

FOCUS = CONCATENATEX(DISTINCT(TB),MAX(TB[Column]),",")

Regards,

[marcos_osorio]

Thank you very much!!

[Anonymous]

try playing around with CONCATENATEX:

https://docs.microsoft.com/en-us/dax/concatenatex-function-dax