Count IF

[BartzD01]

I have a table that contains a product "100000" which is produced at 2 plants 1352 and 1353.

Every plan consumes each own material code (ex. 1352: 200001..200004 & 1353: 200005...200009).

The total produced volume for 1352: 10 and for 1353:20. However the volume 10 & 20 is repeated becuase of the materials. I want one column to devide the times occurence of product 100000 at plant 1352"  10/5 times and 1353"  10/6 times. I used the formula at the picture test to count how many times occures a join of plant&product but did not worked because I guess there is a conflict with the other colums a well. Your help will be gratefull 

[tex628 · Accepted solution]

[Sales]
/
Calculate(
Countrows(Table),
ALL(table),
[Plant] = Earlier([Plant]),
[Product] = Earlier([Product])
)

[Anonymous]

Hi @BartzD01 ,

Please try below measure, it works on my desktop version:

test = CALCULATE(COUNTROWS(Table4),ALL(Table4[MATERIAL],Table4[Sales]))

Aiolos Zhao