Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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
Proud to be a Super User!
@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
Proud to be a Super User!
User | Count |
---|---|
93 | |
85 | |
78 | |
68 | |
62 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |