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?
8 Replies
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
If this is at line level it should work without sum.
It seems like a calculated measure (sales through). based on the level you want calculate
filter = if(sumx(filter(TIDs[col1]=earlier(TIDs[col1])),TID[Sell Through]),,1,0)you can add more conditions
Hi Anonymous ,
If you don't want to see the extra data, you could create a new measure to set rules which returns 1 or 0. Then show data whose measure =1 or 0 in the filter pane.
This is a calculation for Sell Through column that returns expected results.
Now, I'm using the same formula for the "Exlude" column which I would like to use as a filter, however, It doesn't work the way the sell through column does.
you can see that for rows = 1 , it says "Yes". It should say "No" according to formula.
If I don't summarize the "Sell Through" column the "Exclude column" calculates it right and that's what it's doing even when summed up. But this is not what I need. It must be summed up TaskID
I also tried to add a measure which works fine
but when I try to build upon that and do a column that uses that correct measure, it doesn't return the correct results:
I'd really want to know how to overcome this. If it's the best, please message me and I could send you the sample file I work with directly to your email if that's fine.
