counting measure result, and use as filter

[Anonymous]

Backgroud. 

Data

1. Data table ( Machine | Date | Event)

2. Date ( Date | Week | Year )

3. Cust ( Machine | Customer )

Calculations

1. Average  

      Step 1: Total = Sum (Event)

      Step 2: Average = Divide ( [Total] , Distinctcount ('datatable'[Week]),"")      -> Excel Column BM

2. Meet Target? 

       If ( [Average] >= 300, 'Yes','no')   -> Excel Column BO

Question/Need Help

How do i count # of machines that Meet VS Nomeet? 

For example: 

Overall 10 machines, 4 Yes, 6 no

Customer 1 has 4 machines, 2 yes, 2 no. 

Please help! Thanks!

[Anonymous]

@DataInsights Thank you very much! It worked!

[DataInsights · Accepted solution]

@Anonymous, try these measures:

Met Target = IF ( [Average] >= 300, "Yes", "No" )

Met Target Count Yes = 
VAR vMachineTable =
    ADDCOLUMNS ( VALUES ( MachineEvent[Machine] ), "MetTarget", [Met Target] )
VAR vResult =
    SUMX ( vMachineTable, IF ( [MetTarget] = "Yes", 1, 0 ) )
RETURN
    vResult

Met Target Count No = 
VAR vMachineTable =
    ADDCOLUMNS ( VALUES ( MachineEvent[Machine] ), "MetTarget", [Met Target] )
VAR vResult =
    SUMX ( vMachineTable, IF ( [MetTarget] = "No", 1, 0 ) )
RETURN
    vResult