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.
Hello Community,
Is it possible to divide the sum of Scrapped Qty with Manufactured Qty and place the reslut in the first row of Quality Index i.e (50 + 150) / 1000 = 0.8. Right now it takes 50/1000 = 0.95
So what I have done is the following:
Manufactured Qty Filtered :=SUMX(FILTER('Dummy',Dummy[FirstOperation] = 1),[Manufactured Qty])
Quality Index :=DIVIDE([Scrapped Qty],[Manufactured Qty Filtered])
Is this a pivot table or source data table? What are the fields? Are they source data columns/values or measures? What are planning to create, a calculated column or measure?
how many records you have? If many recods you want the same result ( the value of next row) for all rows? What is the next row? Is it something related to operation no.? Is the operation no. A sequential unique number?
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |