Forum Discussion
JennyMilf
1 year agoHelper I
Index column in Table visual
Hello everyone, I have 2 table: Project, and Member How can I create or add index column in my table visual Moji Monitoring based on the condition in slicer? I tried Add Column --> Index Column (fr...
- Anonymous1 year ago
Hi
Please try this:
Here I create a new measure:MEASURE = VAR _vtable = CALCULATETABLE ( SUMMARIZECOLUMNS ( 'Member'[Member Name], 'Member'[Project ], 'Project'[Code], "_Phase Combination", 'Project'[Phase Combination], "_SumIndex", SUM ( Project[Index] ) ), ALLSELECTED ( Project ), ALLSELECTED ( 'Member' ) ) VAR _vtable2 = ADDCOLUMNS ( _vtable, "ABC", RANKX ( _vtable, [_SumIndex],, ASC ) ) RETURN SUMX ( FILTER ( _vtable2, [_SumIndex] = SUM ( Project[Index] ) ), [ABC] )It's noting that the result is obtained through the Index column
The result is as follow:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Akash_Varuna
1 year agoSuper User
Hi JennyMilf You could try with DAX by creating a column or measure then adding it
example dax measure : DynamicIndex = RANKX(ALLSELECTED('Project'), 'Project'[SomeValue], , ASC, Dense)
JennyMilf
1 year agoHelper I
Thanks, but this DAX is not work