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

Need Help

Tips and Tricks

Anonymous

1 year ago

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.

Combine.pbix40 KB

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] )

Forum Discussion

Index column in Table visual

Related content

Fixed Index Column

dummy index column

Column index

Replace Index Column

how to add index column in table/matrix visual