Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Tryingpod
New Member

Daxx

SUMMARIZE(

    ADDCOLUMNS(

        ADDCOLUMNS(

            'table aaaaaaa',

            "Rank", RANKX(ALL('table aaaaaaa'[sessionid]), 'table aaaaaaa'[sessionid], , ASC)

        ),

        "IsFirst", [Rank] = 1

    ),

    'table aaaaaaa'[sessionid],

    "Total Sessions", 

    CALCULATE(

        SUM('table aaaaaaa'[sessions]),

        [IsFi

rst]

    )

)

1 ACCEPTED SOLUTION
v-jiewu-msft
Community Support
Community Support

Hi @Tryingpod ,

Please try the following methods and check if they can solve your problem:

1.Create the simple table.

vjiewumsft_0-1711364135012.png

2.Create the new table to Rank.

Table Rank_id = SUMMARIZE(
    'Table',
    'Table'[sessionid],
    "Total Sessions", 
    CALCULATE(
        SUM('Table'[session])
    ),
    "Rank", RANKX(ALL('Table'[sessionid]), 'Table'[sessionid], , ASC)
)

3.Drag the table into the table visual. The result is shown below.

vjiewumsft_1-1711364226355.png

vjiewumsft_2-1711364235634.png

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

View solution in original post

2 REPLIES 2
v-jiewu-msft
Community Support
Community Support

Hi @Tryingpod ,

Please try the following methods and check if they can solve your problem:

1.Create the simple table.

vjiewumsft_0-1711364135012.png

2.Create the new table to Rank.

Table Rank_id = SUMMARIZE(
    'Table',
    'Table'[sessionid],
    "Total Sessions", 
    CALCULATE(
        SUM('Table'[session])
    ),
    "Rank", RANKX(ALL('Table'[sessionid]), 'Table'[sessionid], , ASC)
)

3.Drag the table into the table visual. The result is shown below.

vjiewumsft_1-1711364226355.png

vjiewumsft_2-1711364235634.png

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

Daniel29195
Super User
Super User

@Tryingpod 

 

SUMMARIZE(

    ADDCOLUMNS(

        ADDCOLUMNS(

            'table aaaaaaa',

            "Rank", calculate(RANKX(ALL('table aaaaaaa'[sessionid]), 'table aaaaaaa'[sessionid], , ASC))

        ),

        "IsFirst", [Rank] = 1

    ),

    'table aaaaaaa'[sessionid],

    "Total Sessions", 

    CALCULATE(

        SUM('table aaaaaaa'[sessions]),

        [IsFirst]

    )

)

 

 

let me know if this works for you . 

 

 

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors