Forum Discussion

iandespradel's avatar
iandespradel
Regular Visitor
5 years ago
Solved

Help with Visuals and Making Measures or Calculated Columns, %Days Worked, %Broken %Standby

I work in a company that lends equipment and machinery for construction projects.   I have +100 equipment, each identify by an unique ID.   I have a log of all the borrowed equipment.(Status: "Ac...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    iandespradel , Try like

     

    % of the days Broken =
    var _tot = countx(equipment,equipment[ID])
    return
    divide(calculate(distinctcount(Table[ID.Equip]), filter(Table, Table[Status] ="Broken")), _tot)

     

    % of the days Active=
    var _tot = countx(equipment,equipment[ID])
    return
    divide(calculate(distinctcount(Table[ID.Equip]), filter(Table, Table[Status] ="Active")), _tot)

amitchandak's avatar
amitchandak
Super User
5 years ago

iandespradel , Try like

 

% of the days Broken =
var _tot = countx(equipment,equipment[ID])
return
divide(calculate(distinctcount(Table[ID.Equip]), filter(Table, Table[Status] ="Broken")), _tot)

 

% of the days Active=
var _tot = countx(equipment,equipment[ID])
return
divide(calculate(distinctcount(Table[ID.Equip]), filter(Table, Table[Status] ="Active")), _tot)

iandespradel's avatar
iandespradel
Regular Visitor
5 years ago

Hey, 

Thanks for the reply.

 

The thing is that the table doesn't have all the calendar days. Just the days the equipment were on site. The rest of the days they were on Standby, and those dates are not in the table.

 

But you give me an idea for a possible solution. Let me check and do a test run.