Count values in tables that are related with condition

[CastroRibeiro]

Table EQUIPMENT has the total equipment in stock and table EQUIPMENT_STATUS only records an occurrence with this equipment. I want to calculate a percentage of equipment that has status 1 and status 0

And for this, I need to count the total of equipment in the EQUIPMENT table that has status 1 in the EQUIPMENT_STATUS table

Any Ideias?

EQUIPMENT

EQUIPMENT_NAME

A

B

C

EQUIPMENT_STATUS

EQUIPMENT_NAME	STATUS
A	1
B	0
C	1

[v-zhangti · Accepted solution]

Hi, @CastroRibeiro 

You can try the following methods.

Measure = 
Var _count=CALCULATE(COUNT(EQUIPMENT_STATUS[STATUS]),ALLEXCEPT(EQUIPMENT_STATUS,EQUIPMENT_STATUS[STATUS]))
Var _allcount=COUNTROWS(EQUIPMENT)
Return
DIVIDE(_count,_allcount)

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vicky_]

Is there any reason you need to have the EQUIPMENT table?
You should be able to get the count of status = 1 with the following DAX:

Equipment Status is 1 = COUNTROWS(FITER('EQUIPMENT_STATUS', [STATUS] = 1))