cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
marcos_osorio Regular Visitor
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
Community Support Team

Re: Line/measure with multiple values

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]),",")

1.png

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
Nick_M New Contributor
New Contributor

Re: Line/measure with multiple values

Community Support Team
Community Support Team

Re: Line/measure with multiple values

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]),",")

1.png

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.
marcos_osorio Regular Visitor
Regular Visitor

Re: Line/measure with multiple values

Thank you very much!!