Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
Hi @Chanleakna123,
You can create a measure below:
TotalGroupByCode= calculate(sum([Minute]),filter(all('Downtime Record(2)'),[Code]=MAX([Code])))
Best Regards,
Qiuyun Yyu
HI @v-qiuyu-msft,
it works on the measure , but when i include in the table , It doesn't work.
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
https://drive.google.com/file/d/1CwmDcbNl0O1eD4QWIlH6z51b18CQY4mm/view?usp=sharing
please click the link
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
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |