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'm trying to sum only one (or I guess the minimum would work) value for each repeating value in another column.
I have a column that duplicates the minimum hours required and then repeats in the table with a different attribute for savings % and the amount of savings across several rows. I'm trying to calculate the initial minimum hours to see the sum of minimum hours just once for each process step ID, since it's the same value but repeated over multiple rows.
so group process step ID, identify the min value (which in this case is all the same), and then do a sum of all the one Min Process Tiime Hours column.
i.e.
group 198 and only show the .25 Min Process Time Hours once, group 199 and only show the .25 min process time hours once, and do a sum of all those minimums.
How would I do this??
Solved! Go to Solution.
@Anonymous - Are all of those columns in the same table? Sorry, it's odd how it is posted so wasn't quite sure. If so, the technique should be:
Column =
MINX(
FILTER('Table',[Process Step ID] = EARLIER([Process Step ID])),
[Min Process Time Hours]
)
Measure =
VAR __ProcessStepID = MAX([Process Step ID])
MINX(
FILTER(ALL('Table'),[Process Step ID] = __ProcessStepID),
[Min Process Time Hours]
)
@Anonymous - Are all of those columns in the same table? Sorry, it's odd how it is posted so wasn't quite sure. If so, the technique should be:
Column =
MINX(
FILTER('Table',[Process Step ID] = EARLIER([Process Step ID])),
[Min Process Time Hours]
)
Measure =
VAR __ProcessStepID = MAX([Process Step ID])
MINX(
FILTER(ALL('Table'),[Process Step ID] = __ProcessStepID),
[Min Process Time Hours]
)
Thanks for the formula! I ended up with a different work around but I do appreciate the help
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 |