Forum Discussion

Fcoatis's avatar
Fcoatis
Post Patron
7 years ago
Solved

CALCULATETABLE

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
 
 
Need Help

2 Replies

  • LivioLanzo's avatar
    LivioLanzo
    Solution Sage
    7 years ago

    Fcoatis

     

    try:

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

    • Fcoatis's avatar
      Fcoatis
      Post Patron
      7 years ago

      Thank you very much!

       

      Thats exactly what I was looking for.

       

      Best Regards