Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Create a new column using the measure

Hi Support team,

 

Is there a way to create a new column using the measures.

for example i have a measure which is active/in active records.i want to convert this measure in to a column which can be used as a slicer for report.

Need Help

5 Replies

  • NaveenGandhi's avatar
    NaveenGandhi
    Icon for Memorable Member rankMemorable Member
    2 years ago

    Hi Anonymous 

    You have to create a calculated column using DAX. Share sample data and expected output with screenshots to understand the problem better.

    If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

    Follow me on LinkedIn!!!

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, Anonymous 

    Thanks for NaveenGandhi and SachinNandanwar positive reply. In fact, your idea would work, writing Column = [Measure] directly. But if your Measure keeps changing, then your Column will need to be regenerated, and the Column's value won't change as the Measure changes

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know.     Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Thanks for the response .

       

      I tried the Cloumn =Measure name 

      but when i put the both column and Mesure in one visual ,both the records not matching at row level,any idea how to fix this.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi, Anonymous 

        As I said above, if your data or Measure's calculation rules change after the Calculate Column is generated, the Calculate Column will not change automatically. If this is not the situation, you can provide some pbix files without sensitive data for testing. Feel free to help you about this problem.

        Best Regards,
        Yang
        Community Support Team