Forum Discussion

BartzD01's avatar
BartzD01
Regular Visitor
7 years ago
Solved

Count IF

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 

 

Need Help
  • tex628's avatar
    tex628
    7 years ago
    [Sales]
/
Calculate(
Countrows(Table),
ALL(table),
[Plant] = Earlier([Plant]),
[Product] = Earlier([Product])
)

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi BartzD01 ,

     

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

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

    Aiolos Zhao

  • tex628's avatar
    tex628
    Community Champion
    7 years ago
    [Sales]
/
Calculate(
Countrows(Table),
ALL(table),
[Plant] = Earlier([Plant]),
[Product] = Earlier([Product])
)