Why it says No such name but there actually is such a name

[GAPER]

I am following the instructions from here

https://community.fabric.microsoft.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Paramet...

[Idrissshatila]

Hello @GAPER ,

so the difference between your query and the blog, is that the blog is referencing a measure while you're referencing a column, so what you need to do is that  wrap this field with a sum, like this

sum( 'power_bi_source_final' [Unrealized Value (USD)] )

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡

[GAPER]

I actually have fixed it as below

TopN Borrower =

VAR SelectedTop = SELECTEDVALUE('TopN'[TopN])

RETURN

SWITCH(TRUE(),

    SelectedTop = 0, sum(power_bi_source_final[Unrealized Value (USD)]),

    RANKX (

            ALLSELECTED(  'power_bi_source_final'[Risk - COUNTERPARTY / ASSET NAME] ),

            sum('power_bi_source_final'[Unrealized Value (USD)])

                )

                  <= SelectedTop,

        sum('power_bi_source_final'[Unrealized Value (USD)])

)

However the table doesn't know to change according to the topN slicer. It keeps returning the full list

[Sandhya1234]

Try this
Unrealized Value USD = sum(power_bi_source_final[Unrealized Value (USD)]

TopN Borrower =

VAR SelectedTop = SELECTEDVALUE('TopN'[TopN])

RETURN

SWITCH(TRUE(),

    SelectedTop = 0, [Unrealized Value USD]),

    RANKX (

            ALLSELECTED(  'power_bi_source_final'[Risk - COUNTERPARTY / ASSET NAME] ),

            [Unrealized Value USD]])

                )

                  <= SelectedTop,

        [Unrealized Value USD])

)

[GAPER]

Unrealized Value USD = sum(power_bi_source_final[Unrealized Value (USD)]

TopN Borrower =

VAR SelectedTop = SELECTEDVALUE('TopN'[TopN])

RETURN

SWITCH(TRUE(),

    SelectedTop = 0, [Unrealized Value USD]),

    RANKX (

            ALLSELECTED(  'power_bi_source_final'[Risk - COUNTERPARTY / ASSET NAME] ),

            [Unrealized Value USD]])

                )

                  <= SelectedTop,

        [Unrealized Value USD])

)

There are multiple error value which i don't even know how to fix.... thanks

[Sandhya1234]

@GAPER Its a Measure. Create measure for Unrelalized (USD) Column and use it.

TopN City = 
VAR SelectedTop = SELECTEDVALUE('TopN'[TopN])
RETURN
SWITCH(TRUE(),
    SelectedTop = 0, [Sales Amount],
    RANKX ( 
            ALLSELECTED(  'Orders'[City] ), 
            [Sales Amount]
                )
                  <= SelectedTop,
        [Sales Amount]
)