Forum Discussion
How do i share a value based on spending time
Hi, ramie ;
Try it.
Measure = SUM([DURATION])/CALCULATE(SUM([DURATION]),ALL('Table') )*CALCULATE(SUM([Value]),FILTER(ALL('Table'),[UOWNER]=MAX('Table'[UOWNER])))the final show:
If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, ramie ;
Try it.
Measure = SUM([DURATION])/CALCULATE(SUM([DURATION]),ALL('Table') )*CALCULATE(SUM([Value]),FILTER(ALL('Table'),[UOWNER]=MAX('Table'[UOWNER])))the final show:
If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
i know long time ago you replied but rsults are not matching.
actually above measure is working fine as what i expected but , i want to modify other way , i tried to modify it but i am unable to do it . i have choosen 1 month date then 4 wo codes has been fetched and their related values , but when i select 1 wo code values getting correct but , if i choose 2 work orders(wo code) result is not correct . The formula taking total time and diving by each one involved in the work . But here a person is not involved in the work , but the total time divide his spent time by total time based on selection which gives me incorrect shared values.
you see below it is showing correct because of single seelction
can you see here result is different because of multiple selection and the person i highlighted , he is not involved in other wo code. the need is total time should be work order only not more that that , if he spent time in other wo codes, then will consider ,can u please suggest me how can i add do modification
v-yalanwu-msft pelase help me in this ant modifcations or any suggestions
Looking forward to your response
Thanks