cancel
Showing results for
Did you mean:
Highlighted
Regular Visitor

## Line/measure with multiple values

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team

## Re: Line/measure with multiple values

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,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
New Contributor

## Re: Line/measure with multiple values

Community Support Team

## Re: Line/measure with multiple values

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,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regular Visitor

## Re: Line/measure with multiple values

Thank you very much!!