Forum Discussion
Use Measure as a Column
If you want to pass values(using slicer) to measure and you want that as the column. Not possible. Because the column is pre-calculated. We can do with Static Values.
The other thing which can do force the context of a row on measure using summarize or values. So that calculation happens at a particular level. Check this link, how calculation have been forced at order level.
if you need more help mark me @
Appreciate your Kudos.
Thanks for your reply amitchandak .
Is there any alternative so that i can convert a dynamic measure to a column and the use it in a matrix chart.
I have tried to create a new table with this three vaues as High, Low and medium but it doesnt fullfil my requiement.
I need to display some thing like this, But here the row labels as High Rotatio, Low Rotation, Medium Rotation are my measures.
Thanks
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
