Forum Discussion
Measure into column
Hello, I'm trying to convert a measure called "Exclude" into a column so that I can use it in a filter. The measure works as expected. Any suggestions on how to accomplish this?
Anonymous
New Column = Measure
I thought I fixed it but the issue is that the sell through column is being summed up.
and the exclude column is looking at the row context when evaluating.
Can I maybe send you a file?
please share a sample pbix file after removing sensitive information
In your initial screenshot , you have shown 2 rows and value of sell-through is same for those two, if change it to %(format), If the additional line is a issue
Were you able to getr into the file I share with you in private messages?
Sell Through column is calculating as it should. I played with % or number for that column but it doesn't effect the "Exlude" column.
Exlude column should return 'no' if Sell Through column = 1 (100%), ELSE Yes.
