DAX calculated table not slicing / dicing in PowerBI or Excel

[Anonymous]

I have the following calculated table

=SELECTCOLUMNS(
             {("ColumnName", Sales[SalesAmount])}
             , "ColumnName", [Value1]
             , "ColumnValue", [Value2]
             )

Sales[SalesAmount] is a measure.

when I slice and dice this table in PowerBI / Excel, ColumnValue does not filter or change at all. Any Idea why?

[Anonymous · Accepted solution]

I think possibly the answer is that the measure value is a column and so its value is set during processing time? I found another solution, so nevermind anyway...