Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to convert a column into measure ?

I have one column which consists of ID in it and I want to convert this column into measure without summarization in it.Is there anyone who knows about it.

 

Thanks in Advance

  • Anonymous , measures means summarization

     

    Display or context is Key

    Like 

    ID is column

    ID measure = max(Table[ID]) is measure

     

    Now in visual if you put not summarized ID with ID measure. It will give the same result.

4 Replies

  • Anonymous , measures means summarization

     

    Display or context is Key

    Like 

    ID is column

    ID measure = max(Table[ID]) is measure

     

    Now in visual if you put not summarized ID with ID measure. It will give the same result.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks amitchandak  

      It is working fine for me 🙂

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion

    Anonymous Hard to be specific without the code but generally it is fairly straight-forward, you wrap your column references in something like MAX, MIN, etc.

     

    Need to see code.

    • Anonymous's avatar
      Anonymous
      Not applicable

      I am getting blank fields in the measure...How to resolve that ?
      Currency is the measure and currencyID is column.