Sum Minutes by line and category

Anonymous · ‎10-20-2020

I have a dataset that has entries with datetime and each entry has a number of minutes (e.g., 44, 12, 16, 31, etc.) and each entry has a column (text) indicating if it is "O" (Operator) or "M" (Mechanical); and another column is the shift the entry was done on e.g., "Shift 1", "Shift 2", or "Shift 3", etc.

I want a measure to show total minutes by day, shift and category (O or M).

Is this a CALCULATE(SUM etc. with Filter(s) or just a SUM with FILTERS ?

Any examples of this sum broken out by two columns?

thanks.

edhans · ‎10-20-2020

Please provide data per the links below so we can assist without making up data that may be wrong and not answer your question. Also provide the expected results.

How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum

Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling

Proud to be a Super User!

MCSA: BI Reporting