Forum Discussion

pcav's avatar
pcav
Icon for Helper I rankHelper I
7 years ago
Solved

Filter contexts with constants

In my never ending quest to understand and apply filter contexts I would be grateful if somebody could point me in the right direction   I have a set of engineers who either INSTALL (IN) or SERVICE...
Need Help
  • MFelix's avatar
    MFelix
    7 years ago

    Hi pcav ,

     

    Believe that you need to make changes on in order to force your working orders to get the IN from the enginners table try this code:

    WorkingHours IN =
IF (
    CALCULATE ( [Hours Booked]; Engineers[Discipline] = "IN" )
        = BLANK ();
    BLANK ();)
[Working Hours])

    In this measure I'm checking if the Booked hours are equal to IN if not will return blank for your measure, we are forcing the filter you added in the table visual for IN.

     

    Regards,

    MFelix

     

LivioLanzo's avatar
LivioLanzo
Icon for Solution Sage rankSolution Sage
7 years ago

Hello pcav ,

 

one way for you to do this is to check if the hours booked returns a value and only then display the working hours

 

WorkingHours = IF(ISBLANK(HOURSBOOKED), BLANK(), WORKINGHOURS)

  • pcav's avatar
    pcav
    Icon for Helper I rankHelper I
    7 years ago

    Thanks for your reply, but this doesn't solve the problem, I still get the "blank" rows for the Service engineer albeit the working hours field is blank.  

    • MFelix's avatar
      MFelix
      Icon for Super User rankSuper User
      7 years ago

      Hi pcav ,

       

      Believe that you need to make changes on in order to force your working orders to get the IN from the enginners table try this code:

      WorkingHours IN =
IF (
    CALCULATE ( [Hours Booked]; Engineers[Discipline] = "IN" )
        = BLANK ();
    BLANK ();)
[Working Hours])

      In this measure I'm checking if the Booked hours are equal to IN if not will return blank for your measure, we are forcing the filter you added in the table visual for IN.

       

      Regards,

      MFelix

       

      • pcav's avatar
        pcav
        Icon for Helper I rankHelper I
        7 years ago

        Thanks very much for taking the time to reply.

         

        This works just great and is MUCH better that the solution I came up with

         

        Regards