The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi Guys, I am new to power bi and in need of a urgent help please. I have work order numbers(wonum) field and woassignedflag field and a jobduration field. now I want to calculate sum(Jobduration) for each distinct wonum where woassignedflag = 1
Can anybody help me on this please, this is very urgent for me. Thanks
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Sample/example data always makes answers more accurate. Totally guessing without it. So, a total guess would be:
Measure = CALCULATE(SUM('Table'[Jobduration]),FILTER('Table',[woassignedflag]=1))
?
Can anybody help me on this please?
http://community.powerbi.com/t5/Desktop/Running-count-unique-flag/m-p/430406#M198294
Thanks
Hi
Greg solution works perfectly and giving the expected output. Are you still looking for something?
Thanks
Raj
Hi yes it did work for the scenario I asked, Thanks a lot for Greg for that.....but I missed to tell something important. As one work order will be assigned to multiple people the job duration for that workorder will the duplicated if I do sum(jobduration). For example if we have wo 1 job duration as 5 hrs. This wo is assigned to 3 Engineers (Enigeeneer 1, Engg 2, Engg 3). Each will have 5 hrs of job duration. So if I do sum(jobduration it gives me 15 hrs instead I want it to show 5 hrs as job duration is unique to workorder.
So my plan after struggling a lot today was to create a flag for unique WO..as posted the link requesting for possible way to achieve it. Can you please help me.. So tha sample data and the output I am looking for is below, I have already got woassigned flag created at the backend. I don't have running - count, Wo Uniquie Flag, and the calculation for sum(Job duration). PLEASE HELP
Wonum | JobDuraint | woassigned flag | Engineer | Running-Count | Wo Uniquie Flag |
1234 | 5 | 1 | Sandeep | 1 | 1 |
1234 | 5 | 1 | Greg | 2 | 0 |
1234 | 5 | 1 | Raj | 3 | 0 |
1234 | 5 | 1 | Kevin | 4 | 0 |
7896 | 10 | 1 | Tom | 1 | 1 |
7896 | 10 | 1 | Sam | 2 | 0 |
7654 | 50 | 1 | Rahul | 1 | 1 |
7654 | 50 | 0 | Sandeep | 1 | 0 |
Output | |||||
Sum(Jobduration) for each distinct WO where woassigned =1 | wonum | ||||
5 | 1234 | ||||
10 | 7896 | ||||
50 | 7654 |
Hi Greg,
Thanks for your reply, I want to include distinctcount(Wonum) as well in the calculation since one workorder may be assigned to multiple people or one workorder may have different job durations. I have posted the sample data can you please check and let me know please
WoNum | JobDuration | WoAssignedFlag | Name | SUM(JobDuration) for distinctcount of Wonum where assigned flag =1 when selected Sandeep in filter | wonum | JobDuration | SUM(JobDuration) for distinctcount of Wonum where assigned flag =1 when selected Greg in filter | wonum | JobDuration | |||
1 | 30 | 0 | Sandeep | 1 | 44 | 5 | 12 | |||||
1 | 21 | 1 | Sandeep | 2 | 10 | 7 | 88 | |||||
1 | 23 | 1 | Sandeep | 4 | 34 | 1 | 78 | |||||
2 | 10 | 1 | Sandeep | 5 | 23 | |||||||
3 | 30 | 0 | Sandeep | |||||||||
4 | 34 | 1 | Sandeep | |||||||||
5 | 23 | 1 | Sandeep | |||||||||
5 | 12 | 1 | Greg | |||||||||
6 | 34 | 0 | Greg | |||||||||
1 | 78 | 1 | Greg | |||||||||
7 | 12 | 0 | Greg | |||||||||
7 | 34 | 1 | Greg | |||||||||
7 | 54 | 1 | Greg |
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
94 | |
88 | |
71 | |
65 |
User | Count |
---|---|
241 | |
124 | |
120 | |
81 | |
79 |