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

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi pcav 

 

You have stated that WorkingHours comes from Date Table. How is your workedhours table structured?

 

Can you post some sample data /  pbix in GoogleDrive or OneDrive and share the link here. This can help formulate a solution.

 

 

Cheers

 

CheenuSing