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              ...
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,

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
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,

marcos_osorio's avatar
marcos_osorio
Helper II
7 years ago

Thank you very much!!