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 (from 1) but it's doesn't work. Can anyone please help me to implement it? Thanks

 

Refer to my Dashboard 

Need Help
Tips and Tricks
  • 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.

     

4 Replies

  • Akash_Varuna's avatar
    Akash_Varuna
    Super User
    1 year ago

    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)

  • Fowmy's avatar
    Fowmy
    Super User
    1 year ago

    JennyMilf 

    While creating a table or calculated column in Power BI, capturing slicer selections in real-time isn't feasible. Power BI constructs tables and columns before making them available on the report canvas. 
    A measure can be created using Rank function. Let me know if this is helpful or provide the logic of the index you need to create.


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