Forum Discussion

FabianB's avatar
FabianB
Frequent Visitor
3 years ago
Solved

DAX - Count all rows from a dimension table with values below a max in a fact table

Hi,   I am trying to develop a DAX measure. I have a dimension table (dim_machines) that contains a name column. I have a fact table (machine_measurements), linked to the dimension table by this ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Count Machines < 20 =
    COUNTROWS(
    FILTER(dim_machines,
    NOT(COUNTROWS(FILTER(machine_measurements, machine_measurements[power] > 20 && machine_measurements[name] = dim_machines[name])) > 0)
    )
    )

     

    Hey could you try this and let me know if it works? Thanks! 🙂 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Count Machines < 20 =
COUNTROWS(
FILTER(dim_machines,
NOT(COUNTROWS(FILTER(machine_measurements, machine_measurements[power] > 20 && machine_measurements[name] = dim_machines[name])) > 0)
)
)

 

Hey could you try this and let me know if it works? Thanks! 🙂