Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

URGENT!! Convert Measure to Calculated Column

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.    Ra...
"DAX help"
"RANKX"
  • Anonymous's avatar
    Anonymous
    2 years ago

    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:

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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: