Table created by SUMMARIZECOLUMNS, can I add measure to it?

[River]

Hi Friends,

I created a table by SUMMARIZECOLUMNS, then I need to caculate a ratio between two columns, so I want to add a measure for it. But, it keeps telling me the columns' name is not right. 

Can I add measure? if I can, how do I reference the column name?

If I can't do all above, what's other alternative? 

New to DAX, appreciate any hint or suggestion.

River

[Fowmy]

@River 

The best practice is to use ADDCOLUMNS and SUMMARIZE functions:

https://www.sqlbi.com/articles/best-practices-using-summarize-and-addcolumns/

[River]

Hi Fowmy,

Do you mean, instead of using 'SUMMARIZECOLUMNS' to create new table, just using ADDCOLUMNS and SUMMARIZE to add to existing table? 

Or, use it on this new table? 

[Fowmy]

@River 

Use ADDCOLUMNS and SUMMARIZE to create the new table