Calculate Total by categories on measure on table

[Chanleakna123]

Hi , i have above table. I'd like to sum by code such as what is the total of OP , EP , PM , PS by date. do we have any way to create another measure ? because the total of OP , EP , PM , PS will be calculated to another table. 
your response is much apprecaited. 
Thx 

[v-qiuyu-msft]

Hi @Chanleakna123,

You can create a measure below: 

TotalGroupByCode= calculate(sum([Minute]),filter(all('Downtime Record(2)'),[Code]=MAX([Code])))

Best Regards,
Qiuyun Yyu

[Chanleakna123]

HI @v-qiuyu-msft, 
it works on the measure , but when i include in the table , It doesn't work. 

[v-qiuyu-msft]

Hi @Chanleakna123,

Would you please share the pbix file with us? You can upload to your OneDrive and send the link tome via private message. Thanks. 

Best Regards,
Qiuyun Yu

[Chanleakna123]

https://drive.google.com/file/d/1CwmDcbNl0O1eD4QWIlH6z51b18CQY4mm/view?usp=sharing

please click the link 

[v-qiuyu-msft · Accepted solution]

Hi @Chanleakna123,

I have looked into your pbix file. I modified the relationships in attached file. When you create relationships, you can refer to this document firstly: https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships

The error you get last time due to 'EPL'[Code]' is not number data type, so we can't use sum() function. The updated measure below: 

Total By Group = CALCULATE(SUM('Downtime Record (2)'[Minute ]);FILTER(ALLSELECTED('Downtime Record (2)');CONTAINS(FILTER(ALL(EPL);EPL[Code ]=MAX(EPL[Code ]));EPL[SAP Code];'Downtime Record (2)'[EPL])))

Best Regards,
Qiuyun Yu