use mesure as filter. but doesn't work.

[erikzzy]

Hello everyone,

I want to use one measure recent as filter. My power bi use DirectQuery. So I can't use calculate or maxx to add one calculated column.

As the first print screen, I want to only keep recent = 0.

So I add recent in filter section. Then I choose  recent is 0.

Recent is a measure for choose the most recent record. 

Finally, the result is blank. 

Thanks a lot!

[amitchandak · Accepted solution]

@erikzzy , Seem like you need data when created at = updated at individual table

calculate([Recent],report[createdate]=report[updatedat])
or
calculate([Recent],filter(report,report[createdate]=report[updatedat]))

[erikzzy]

Hello @amitchandak,

Thanks your reply, 

I have tried your solution. 

If I use measure 2 to filter, my table is blank like this,

 And  I can't understand what do you meaning in an individual table. I need a new table only one measure [recent]?

Thank you again,

ErikZhang

[AiolosZhao]

Hi @erikzzy ,

I have a workaround for you, if your table only has this measure.

Then you can try to create another measure or change the recent to the below one:

if recent = 0, 0, blank()

And I think the table will show what you want.

Please try.

Aiolos Zhao

[erikzzy]

Hi @AiolosZhao ,

Thanks your reply.

I try your solution. But in fact there lastDate is another measure. So my table do not work.
I have tried your proposition,

[AiolosZhao]

Hi @erikzzy ,

Could you please show some sample data and the result that you want in a screenshot or excel?

Thanks.

Aiolos Zhao

[erikzzy]

Thanks your reply. I found a problem of data modelling.