Forum Discussion
Solved
Measure to create dynamic label in table
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 |
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
3 Replies
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
thank you
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?
