Forum Discussion
Use Measure as a Column
Hello, I have a requirement where in I have created three what if parameters and created measures for it as follows. Measure 1: ABC Cogs = Var A = SELECTEDVALUE('A Anlysis'[A Anlysis]) Var...
In general, this is going to involve some form of the Disconnected Table Trick because you are trying to use a measure where you are not allowed to use a measure.
Beyond that, very difficult to tell without sample source data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba-p/279563