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...
Need Help
  • tex628's avatar
    tex628
    7 years ago
    [Sales]
/
Calculate(
Countrows(Table),
ALL(table),
[Plant] = Earlier([Plant]),
[Product] = Earlier([Product])
)
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