Forum Discussion

pcav's avatar
pcav
Helper 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

     

MFelix's avatar
MFelix
Super 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
Helper 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