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

     

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
7 years ago

Hi pcav 

 

One option would be to use a visual level filter and on Discipline-->IN

A second option would be to create a slightly modified WorkingHours measure that is only non-blank when Discipline = "IN"

 

 

WorkingHours_IN =
IF ( SELECTEDVALUE ( Table1[Discipline] ) = "IN", [WorkingHours] )

This assumes  Table1[Engineer] in the rows of the matrix visual as you show.