topic Re: How to create an additional column of text in DAX Commands and Tips

How to create an additional column of text

Thulasiram — Wed, 19 Jun 2024 07:52:29 GMT

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.

PijushRoy — Wed, 19 Jun 2024 08:13:26 GMT

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

rajendraongole1 — Wed, 19 Jun 2024 08:26:35 GMT

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!!

Thulasiram — Tue, 25 Jun 2024 06:30:15 GMT

Thank you very much rajendraongole1 .

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

Thulasiram — Tue, 25 Jun 2024 06:30:32 GMT

Thank you PijushRoy