custom column for DirectQuery report

[Anonymous]

Hello, I created report using import data option and made this custom column. This column works in import version of report but now I need to create it in the DirectQuery version of the report and when I try to use same formula I get message that SUM function is not supported in DirectQuery model.  Is there a way to create column that would produce same results. For the record this column is being used in slicer visual to filter table that has conditional formating. Thank you.

[Anonymous]

Could anyone close this topic I reposted more detail one in forum section that is more appropriate to the problem I have.

[Anonymous]

Anyone know how this function can be used in Measure to archieve slicer capabilities or modified so it would still be available to with slicer visual?

[Greg_Deckler]

You cannot create columns in Direct Query reports, you can only create measures.

[Anonymous]

I created new columns for other functions using switch DAX function or date diff functions and didnt get any problems.