topic URGENT!! Convert Measure to Calculated Column in DAX Commands and Tips

URGENT!! Convert Measure to Calculated Column

Anonymous — Fri, 08 Mar 2024 14:35:21 GMT

Hello Power BI community!

Need some urgent help in converting the following measure to a calculated column. The min purpose is that I can use this new column as a legend for my pie chart.

Ranking SingleSelect = 
RANKX(ALLSELECTED('df_Search Order (First)'[Search Order (First)]), [Category_Occasion_SingleSelect%], , DESC, Dense)

@MFelix , @amitchandak , @Ashish_Mathur

Re: URGENT!! Convert Measure to Calculated Column

lbendlin — Sat, 09 Mar 2024 17:24:26 GMT

This here is a forum where users help users, time permitting. For urgent requests contact a Microsoft partner near you.

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?

Re: URGENT!! Convert Measure to Calculated Column

Sahir_Maharaj — Sat, 09 Mar 2024 17:45:50 GMT

Hello Anonymous,

Can you please try the following:

Ranking SingleSelect = RANKX( ALL('df_Search Order (First)'), CALCULATE(SUM('df_Search Order (First)'[Category_Occasion_SingleSelect%])), , DESC, Dense )

Re: URGENT!! Convert Measure to Calculated Column

Anonymous — Mon, 11 Mar 2024 05:57:39 GMT

Hi, Anonymous

Based on your DAX, I used the following sample data:

I'm using the following DAX expression in the calculated column for ranking:

Ranking SingleSelect = RANKX ( 'df_Search Order (First)', [Category_Occasion_SingleSelect%], , DESC, DENSE )

Here are the results:

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

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

Re: URGENT!! Convert Measure to Calculated Column

Anonymous — Mon, 11 Mar 2024 06:44:42 GMT

Hello Anonymous

Thanks for helping here!

But I'm getting this error here when I run this code. This might be because [Category_Occasion_SingleSelect%] is a measure. Can there be another way?

Also, I'm trying to convert this into a column because I want to use this as a legend in my pie chart. But I cannot add a measure as a legend.

Re: URGENT!! Convert Measure to Calculated Column

Anonymous — Mon, 11 Mar 2024 06:45:41 GMT

Hello Sahir_Maharaj

Thanks for helping here!

But I'm getting this error here when I run this code. This might be because [Category_Occasion_SingleSelect%] is a measure. Can there be another way?

Also, I'm trying to convert this into a column because I want to use this as a legend in my pie chart. But I cannot add a measure as a legend.

Re: URGENT!! Convert Measure to Calculated Column

Anonymous — Mon, 11 Mar 2024 09:19:50 GMT

Hi, Anonymous

Thank you very much for your reply. Here's how I handle ranking with measure in calculated columns:
1. First of all, use the summarize function to summarize the measure, here I simply create a measure as shown in the following photos:

I use the following DAX to call this measure and generate a calculation table:

Table = SUMMARIZE ( 'df_Search Order (First)', 'df_Search Order (First)'[Search Order (First)], "result", [category_Occasion_%] )

Here are the results:

You need to replace [category_Occasion_%] with your measure.

2. Create a connection for the two tables:

3.The following DAX is used for ranking in the original table:

Ranking SingleSelect = RANKX ( 'df_Search Order (First)', RELATED ( 'Table'[result] ),, DESC, SKIP )

Here are the results: