Convert measure to dimension & measure

Hello everyone.
I'm seeking to create a dimension from a current measure column so that I have this column visible as both a measure and dimension.
Cheers, Dave

2 replies

    • Senior Director of Product
    • Ian_Macdonald
    • 1 yr ago
    • Reported - view

    Hi Dave,

    You simply need to check the box in the first column of the Table in Model:

    Then reprocess the Model. You only need to process the Model, you don't need to rerun the Data Flow if it has one.

    In this case, Sales will now also appear as a dimension:

    Hope that helps.


      • Dave_Carbery
      • 1 yr ago
      • Reported - view

      Ian Macdonald thank you very much...I reckon the simplicity of what I was trying to do made it difficult to see!

Content aside

  • Status Answered
  • 1 yr agoLast active
  • 2Replies
  • 98Views
  • 2 Following