Forum Discussion
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...
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.
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.
Rob,
Thanks it works, one more question can you do Group By clause with this solution? (I didn't try)
Thanks
Oded Dror
Hi Anonymous ,
From what I understand, by default, SUMMARIZE function cantains a built in Group By clause. For example, regarding the table you've just created, you will find only distinct value in your Job_ID column.If you want to use a more explicit group by clause, try using GROUPBY function instead of SUMMARIZE.
Cheers,
RobThanks Rob