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
Icon for Super User rankSuper 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.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi MFelix ,

    I am not sure whether i got this or not. As you said create new table like this :


    After that you said create new measure in your data model (in existing table CV_SOP) and whe i tried i am getting confused which table we need to refer in the formula. Please look below:

    Now i am not sure which table i should refer to enter value ?

    Can you please share the sampe PBIX?

     

    Regards,

    Ashish

    • MFelix's avatar
      MFelix
      Icon for Super User rankSuper User
      2 years ago

      In this measure you need to erefer to the values from the new table and the metrics are the ones you are using.

      In my example I called the table Key Measures. In your case you need to pick up the New_Table[Measure] not the New_Table[Key_Figure].

      The Key_Figure is to be used on the matrix visualization not on the measure itself

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi MFelix ,

        Its again blowing my mind as i am not able to create this formula .

         

        If you see i have create a new Measure in my existing table (CV_SOP) and as soon as i entered column name "Booked _Sales-Order" and then i try to add Result its giving me error.

        So which column it should come here"?

        Can you check in above screen shot?

         

        Thanks,

        Ashish