Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago
Solved

Measure looking for value in another table

Hello, I expose my case to see if you can help me again. I have 2 related tables (DAILY Table and HISTORICAL Table) by the "Supervisor" column and also by the "Operator" column (although this rel...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Syndicate_Admin ,

    I have created a simple sample, please refer to it to see if it helps you.

    Create meaures.

    Incidents = CALCULATE(SUM(history[Incidents]),FILTER(ALL(history),history[Supervisor]=SELECTEDVALUE(daily[Supervisor])))
    Supervisor1 = var _1= CALCULATE(SUM(history[Incidents]),FILTER(ALL(history),history[Supervisor]=SELECTEDVALUE(daily[Supervisor])&&history[Operative]=SELECTEDVALUE(daily[Operative])))
return
IF(_1=BLANK(),0,_1)

     

    If I have misunderstood your meaning, please provide mroe details with your desired output.

     

    Best Regards

    Community Support Team _ Polly

     

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

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

I didn't quite understand his solution.

The "HISTORICO" table has more than 300,000 records. According to your solution, would you have to duplicate some columns of this table (supervisory date) to make new relationships? I think that would make the report much heavier than it already is now.

I was trying to do something with the CALCULATE, FILTER and ALL functions but I did not get the expected result.