If condition based on measure

Hey Anonymous ,

yes, that's possible. But you need a filter context for the measure, so you have to create a virtual table of all employees first in the measure. Then you can add the measure for the virtual table or check your criteria there directly and at the end summarize your result and return it.

The following approach should work for you:

Number employees with more than 10 hours =
-- Returns a distinct list of Employees
VAR vAllEmployees = VALUES( myTable[Employee] )
-- Then you add the measure to that table
VAR vAddMeasure =
    ADDCOLUMNS(
        vAllEmployees,
        "@MoreThan30Hours",
            IF(
                [measure hours that an employee has worked] > 30,
                1,
                0
            )
    )
RETURN
    -- At the end you can sum up the amount of employees who worked more than 30 hours
    SUMX(
        vAddMeasure,
        [@MoreThan30Hours]
    )

[Your Measure] =
countrows(
  filter(
    summarize(
      FactTable,
      Employee[EmployeeID]
    ),
    [1a. measure] > 30
  )
)