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.
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
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |