Measure into column

[Anonymous]

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?

[v-eachen-msft]

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.

[Anonymous]

@v-eachen-msft 

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. 

[VasTg]

@Anonymous 

New Column = Measure

[Anonymous]

@VasTg  @amitchandak 

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?

[amitchandak]

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

[Anonymous]

@amitchandak 

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. 

[amitchandak]

please share a sample pbix file after removing sensitive information

[amitchandak]

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