Search for answers here or ask a question
0

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

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

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