Forum Discussion

onebrady's avatar
onebrady
Regular Visitor
8 years ago
Solved

Date Calculation and Filtering Issues

I am working with a TimeClock database.  This database tracks Projects performed in an auto repair shop.   The employees clock in and clock out of each job.  The "Job"  has a specific code.  Multip...
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Try this measure

     

    =IF(HASONEVALUE(Data[CostCode]),[your measure],CALCULATE([your measure],ALL(Data[CostCode])))

     

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

Try this measure

 

=IF(HASONEVALUE(Data[CostCode]),[your measure],CALCULATE([your measure],ALL(Data[CostCode])))

 

Hope this helps.

  • onebrady's avatar
    onebrady
    Regular Visitor
    8 years ago

    This actually helped a great deal.  I wasn't aware of how to use ALL()

     

    Thank you so much Ashish