topic Re: Measure to create dynamic label in table in DAX Commands and Tips

Measure to create dynamic label in table

tonyc — Fri, 20 Oct 2023 07:25:34 GMT

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

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

Re: Measure to create dynamic label in table

Anonymous — Mon, 23 Oct 2023 02:07:58 GMT

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

Re: Measure to create dynamic label in table

tonyc — Tue, 24 Oct 2023 08:48:35 GMT

thank you

Re: Measure to create dynamic label in table

tonyc — Tue, 07 Nov 2023 02:01:27 GMT

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?