Index column in Table visual

[JennyMilf]

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 

[Anonymous · Accepted solution]

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.

[Fowmy]

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

[Akash_Varuna]

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]

Thanks, but this DAX is not work