Forum Discussion

JennyMilf's avatar
JennyMilf
Helper I
1 year ago
Solved

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...
  • Anonymous's avatar
    Anonymous
    1 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.