Is there any sequence on Calculate, Filter & Relationship

[AntrikshSharma]

@pedroccamara refer to this post and if still something isn’t clear then let me know.

CALCULATE Mantra

Here are some steps that I recite when I am stuck with a complex problem, it is always good remember CALCULATE’s execution order. Evaluates all the filter arguments of CALCULATE in the original filter context that is active outside CALCULATE and then are kept aside CALCULATE creates a new Filter by copying the original filter context If it is called in a Row Context, either by an iterator or Calculated column then it takes that particular row and create an equivalent filter from values …

Here is the evaluation order of your measure, refer to the comments inside the code:

Hours (Not Charged) =
CALCULATE (
    [T Tempo], -- Fourth Step Evaluate this measure in the modified filter context
    FILTER (
        'Tab Time',
        'Tab Time'[Client#] = 0
    ), -- First Step - This part is evaluated in the filter context outside CALCULATE
	   -- Third Step - Once the relationsip is modified the result of FILTER is applied to the filter context and the 
                       first condition/measure is evaluated.
    USERELATIONSHIP ( 'Table Dates'[Date], 'Tab Time'[Date] ) -- Second Step - This part changes the relationship 
)