Search for answers here or ask a question

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

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Ian MacdonaldAdmin
    • Team Lead - Product Management
    • Ian_Macdonald
    • 1 mth 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.


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

Like Follow
  • Status Answered
  • 1 mth agoLast active
  • 2Replies
  • 48Views
  • 2 Following