Pivot/Unpivot in a DAX measure function.

So I was wondering if it was possible to Pivot/Unpivot some columns in a table without having to do it in query editor, is this possible?   *The reason why I ask is that when I pivot the table my p...