CONTAINS with virtual tables

[luizahenriques]

I need to use CONTAINS using virtual tables but I don't the better way.

This measure must return TRUE of FALSE if the column "Primeiros Caracteres" of  table f_Ciclo (with actived relationship between f_Ciclo(Ciclo) e dCicloAnterior(Ciclo)) is contained in column "Primeiros Caracteres" of  table f_Ciclo ((with actived relationship between f_Ciclo(Ciclo) e dCicloAtual(Ciclo)).

In other words, i need to use CONTAINS but with the same table (with different filters). I don't know to do it without to use virtual tables. But CONTAINS doesn't support it.

Can you help me, please?

[v-xiaotang]

Hi @luizahenriques 

Thanks for reaching out to us.

I'd like to help you, but there's no sample data.  could you share some sample data or .pbix file and the expected output? thanks.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.