Measure to create dynamic label in table

[tonyc]

Is it possible to do in a measure to build a dynamic label in a table? 

From this table 

Group	VOL
A	178
B	225
C	126
D	157
E	76
F	238
TOTAL	1000

I want to expand F by divide by 4

to 

Group	VOL
A	178
B	225
C	126
D	157
E	76
F 1	59.5
F 2	59.5
F 3	59.5
F 4	59.5
TOTAL	1000

[Anonymous · Accepted solution]

Hi  @tonyc ,

Here are the steps you can follow：

1. Create calculated table.

True =
var _table=
FILTER('Table',[Group]="F")
var _table1=
GENERATE (
    _table,
    SELECTCOLUMNS (
        GENERATESERIES ( 1, 4),
        "Index", [Value]
    )
)
var _table2=
ADDCOLUMNS(
    _table1,"Group1",[Group]&" "&[Index])
var _table3=
SUMMARIZE(
    _table2,[Group1],"VOL",MAXX(_table2,[VOL]) / 4)
return
UNION(
    FILTER('Table',[Group]<>"F"),_table3)

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[tonyc]

the original source is not a table. It is a visualisation table. VOL is a measure.

VOL = CALCULATE(

     ( [A1 ] * [A1 WEIGHT]) +

    ( [A2] * [A2 WEIGHT] ) +

    ( [A4] * [A4 WEIGHT] ) +

    ([A3] * [A3 WEIGHT])

   )

 How can i change Electing to Electing 1, Electing 2, Electing 3 and Electing 4 with 59,5% each?

[tonyc]

thank you