How to create an additional column of text

[Thulasiram]

Dear all,

 I have created a Matrix conaining Top N suppliers.

I have created a measure to get the top n.

I wish to create a new column in the matrix wherein I will put

some random remarks against each supplier with a measure.

Need help.  Thanks and appreciate.

[Thulasiram]

Thank you very much @rajendraongole1 .

It solved my problem.  Thanks for taking time in giving the dax code which was very helpful.

[rajendraongole1 · Accepted solution]

Hi @Thulasiram - Create below measure with your main kpi and add text details like remarks for each supplier in a matrix in Power BI using a measure.

TopNSupplierRemarks =

IF(

    RANKX(ALL('financials'), [profittotal], , DESC) <= 2,  -- Change 5 to your Top N count

    SWITCH(

        TRUE(),

        SELECTEDVALUE('Financials'[Product]) = "Product A", "Remark for Product A",

        SELECTEDVALUE('Financials'[Product]) = "Product B", "Remark for Product B",

        SELECTEDVALUE('Financials'[Product]) = "Product C", "Remark for Supplier C",

        "Default Remark"

    ),

    BLANK()

)

I have defined rank with 2 , you can change the count as per your requirement.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[PijushRoy]

Hi @Thulasiram 

Please use RANKX for define topn customer https://databear.com/how-to-use-the-dax-rankx-function-in-power-bi/ and then define rank wise note in measure with SWITCH statement

[Thulasiram]

Thank you @PijushRoy