Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Convert Measures to a table

Hi there,   I have Job_Id and two Measures JobComplete (Precentages) and Margin (Also Presentages) I would like to create a line chart with X-axes as Jobcomplete but you cant put measure as x-axes...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous  ,

    Here is how to create new table:
    Go to MODELLING tab and select NEW TABLE.

     

    The DAX to create new table is like below:

    Table 2 = 
CALCULATETABLE( 
         SUMMARIZE( 'Table1'
                             ,'Table1'[Job_Id] 
                             , "JobComplete" , [JobComplete] 
                              , "Margin" , [Margin]
                              ) )

    Let me know if that helps. If not please share your .pbix file
    Cheers
    Rob

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

hoang_vaeco's avatar
hoang_vaeco
Regular Visitor
2 years ago

I don't know what is Table 1. If i have only two measure and want to combine in  a table to draw a bar chart, how can do ?