CALCULATETABLE

[Fcoatis]

Hello community,

Is there a way to accomplish this:

CGJOBS Reduced = CALCULATETABLE(CGJOBS;CGJOBS[JOB]=VALUES(realocJOBS[JOB]))

I have big table CGJOB and I want to reduce it  (I mean filter) using the distinct values of an unrelated table´s column.

Thanks in advance

[LivioLanzo · Accepted solution]

@Fcoatis

try:

CGJOBS Reduced = CALCULATETABLE(CGJOBS;CGJOBS[JOB] IN VALUES(realocJOBS[JOB]))

[Fcoatis]

Thank you very much!

Thats exactly what I was looking for.

Best Regards