Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
[Sales] / Calculate( Countrows(Table), ALL(table), [Plant] = Earlier([Plant]), [Product] = Earlier([Product]) )
[Sales] / Calculate( Countrows(Table), ALL(table), [Plant] = Earlier([Plant]), [Product] = Earlier([Product]) )
Hi @BartzD01 ,
Please try below measure, it works on my desktop version:
test = CALCULATE(COUNTROWS(Table4),ALL(Table4[MATERIAL],Table4[Sales]))
Aiolos Zhao
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |