Forum Discussion

marcos_osorio's avatar
marcos_osorio
Helper II
7 years ago
Solved

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.

 

 

Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    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,

3 Replies