Forum Discussion
impact % h on company, Ranking
I have a fact table with these relevant columns:
Zlecenie – the order/job id
RBH – hours
Nazwa_APT_FZ – company name
(optional filter) Rodzaj_towaru – product type (will be on a slicer)
i need information wich Nazwa_APT_FZ
I need to have a measure that tells me what impact the company has on reducing the total number of hours. I suspect that I need to calculate the percentage of the total on the order and then create a ranking.
All collumns is in one Tabel
RBH_SQL.
Hi Sand36,
Thank you for reaching out to the Microsoft fabric community forum. Also, thanks to ThomasWeppler, for his inputs on this thread. I reproduced the scenario, and it worked on my end. I used it as sample data and successfully implemented it.
outcome:
I am also including .pbix file for your better understanding, please have a look into it.Hope this clears it up. Let us know if you have any doubts regarding this. We will be happy to help.
Thank you for using the Microsoft Fabric Community Forum.
7 Replies
v-kpoloju-msftCommunity Support
Hi Sand36,
Thank you for reaching out to the Microsoft fabric community forum. Also, thanks to ThomasWeppler, for his inputs on this thread. I reproduced the scenario, and it worked on my end. I used it as sample data and successfully implemented it.
outcome:
I am also including .pbix file for your better understanding, please have a look into it.Hope this clears it up. Let us know if you have any doubts regarding this. We will be happy to help.
Thank you for using the Microsoft Fabric Community Forum.
- v-kpoloju-msft
Hi Sand36,
Just checking in to see if the issue has been resolved on your end. If the earlier suggestions helped, that’s great to hear! And if you’re still facing challenges, feel free to share more details happy to assist further.Thank you.
- v-kpoloju-msft
Hi Sand36,
Just wanted to follow up. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.Thank you.
- ThomasWeppler
Impactful Individual
When you say the impact on reducing do you mean how many procent the hours a company uses has changed since the same periode last year?
Thanks
No, I want to know what impact the percentage share of hours on a job has on the reduction of total hours on the assignment. In other words, which company completes the job fastest, taking into account that several companies can work on one assignment, always in a different configuration of hours.- ThomasWeppler
So you want a list of all the time a job has each job has been done.
Make a slicer that let you pick a job. (just put the job id into a slicer.)
Make a table where you have the id for each time the job has been completed, maybe and index if you do't have a uniq id, but an uniq id id better.
add the hours to the table.
Hours = selectedvalue(order[hours])
Write in Dax a code that look at the average time spend on the task.
Average = divide(selectedvalue(order[hours], sum(order[hours],0)
Write a new dax that looks at the diffrence.Saved time = [Average] - [Hours]
I am not sure about all the name of the table since I don't have much info, but this might get you started. 🙂RBH Zlecenie Nazwa_APT_FZ 4 KW A 5 KD B 6 KX C 7 KW A 3 KD A 2 KX C 4 KW C 6 KD A 3 KX D 4 KW D
This is my Tabel 🙂 i wloud like to know wich company is Making my Zlecenie fastest.
Because some company work slow and id i put them on Zlecenie they need much more hours to end Zlecenie.
In tabel i have only Ended Zlecenie.Suma z RBH Etykiety kolumn Etykiety wierszy A B C D Suma końcowa KD 20,45% 11,36% 0,00% 0,00% 31,82% KW 25,00% 0,00% 9,09% 9,09% 43,18% KX 0,00% 0,00% 18,18% 6,82% 25,00% Suma końcowa 45,45% 11,36% 27,27% 15,91% 100,00%
