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.

     

     

MFelix's avatar
MFelix
Super User
2 years ago

Hi Anonymous ,

 

This is related to the fact that you are adding measures to your matrix and when you place them in row they get repeated altough they do not have any values this is related with te context and the way the setup is done.

 

Can you please share the model setup?

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi MFelix ,

Thank you for your prompt resposne. Yes you are correct i have created measure for those but i have tried using those columns into "Values" field and still i am getting the same result .

I can share you images of my Model if it works for you.



Please see below and let me know if we can do something on this .

Regards,

Ashish

  • MFelix's avatar
    MFelix
    Super User
    2 years ago

    Where does the Key figure column comes from?

    Just to understand the full matrix setup

      • MFelix's avatar
        MFelix
        Super User
        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.