Forum Discussion

MachisukiJ's avatar
MachisukiJ
Icon for Helper I rankHelper I
3 years ago

Filter the top 5 equipments

Good morning, im having some trouble making an graph that shows the top 5 equipments that had more time stopped and that stopped more times, for an example m1 stopped 30 times and it counts 80 hours ...
Need Help
Show and Tell
Tutorial Requests
Kishore_KVN's avatar
Kishore_KVN
Icon for Solution Sage rankSolution Sage
3 years ago

Use ALLEXCEPT on the equipment and then create RANK on it this will help you to get the total for that particular equipment irrespective of the period. 

MachisukiJ's avatar
MachisukiJ
Icon for Helper I rankHelper I
3 years ago

so how do i need to use the ALLEXCEPT im kinda new with dax formula, i need to create a second calculated column or do i just need to put it into the formula ?