Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Unpivot columns

Hi Everyone,   I am trying to create similar values in which i have few columns and i want to see if value in Key Figure column is equal to "Requested Sale Order" then it should only give me the va...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • MFelix's avatar
    MFelix
    2 years ago

    Hi Anonymous ,

     

    Sorry for the late reply create a new table with the following data:

     

    Measure Key Figure
    Requestes_Sales_Order_Value Requested Sales Order
    Shiped_Sales ShippedSalesOrder
    Shiped_Sales_Order_Value ShippedSalesOrder

     

     

    Add the following measure to your model:

    Measures for Matrix = SWITCH(SELECTEDVALUE('Key Figures'[Measure]), 
                            "Requestes_Sales_Order_Value", [Requestes_Sales_Order_Value],
                            "Shiped_Sales", [Shiped_Sales],
                            "Shipes_Sales_Order_Value", [Shipes_Sales_Order_Value])

    Now use the columns on the matrix rows and the measure on the values:

    If you want you can also add a ID column for the sorting of the data.

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi MFelix ,

i am really sorry to bother you again but i have tried creating the same measure and i got it but as soon as i am placing that Measure in Values its giving me blank value .
I tried entering the New Table[Key_Figure] in Row level with week number in Column but i am getting blank values there.

 

I am not sure what went wrong. Please see below images :


MFelix's avatar
MFelix
Super User
2 years ago

To use this option the tables needs to be unrelated, delete the relationship between both tables and check if it returns what you need, you also need to add the measure column to the rows after the Key Figure (both of them must be from the new table).