I have 5 location and 2 type drivers : full time and part time .
Full time (FT ) I have this full count every Friday in my system.
Part Time (PT) works 5 working days a week and one day for driver is 0.2 in the system. I need to create PT fte which stands for “Part time equivalent” .
The ‘Actual PT fte’ calculation is based on:- PT ‘days in use’ across the week * 0.2 = PT fte.
My the most important measure is: The ‘Actual All FT+PT Fte’ calculation is made up of:- All FT drivers + PT Fte drivers in the week = Actual All FT + Pt Fte.
I have weekly count ( on every Friday) but I am struggling with doing this process for financial periods.
Could you please help to figure this out as my number so far doesn’t make any sense
I am attaching doc with all measures for FT and PT DCB - forum.pbix (41.8 KB) DCB_COMPLAINTS.docx (17.7 KB)
Later, I need to use them to calculate some ratios related to different aspects of my project.
Hi @Iwona, we aim to consistently improve the topics being posted on the forum to help you in getting a strong solution faster. While waiting for a response, here are some tips so you can get the most out of the forum and other Enterprise DNA resources.
Use the forum search to discover if your query has been asked before by another member.
When posting a topic with formula make sure that it is correctly formatted to preformatted text </>.
Use the proper category that best describes your topic
Provide as much context to a question as possible.
Include the masked demo pbix file, images of the entire scenario you are dealing with, screenshot of the data model, details of how you want to visualize a result, and any other supporting links and details.
I noticed there are some problems with relationships in your data model.
I cancelled the OnlyFriday table and added a column in the date table which tells whether is friday or not in order to recreate the slicer you wanted and then I fixed the relationship between financial period and date table.
Now you can slice by financial period; financial period empty values are those periods which do not have a corresponding date in Dates table.
I also considered your measures provide correct results
The issue was caused by bidirectional relationship between “OnlyFriday” table and dates table. It directly filters dates table and FY table indirectly. This is because you have an other bidirectional relationship between FY and Dates Table. To solve the issue you just need to remove the OnlyFriday table and relate Dates table to “DataSOBRDB” table using “Date” field.
In this way FY table filter dates Table and, in turn, dates table filters “DataSOBRDB”.
You can keep bidirectional relationship between FY and Dates if you want but, as best practice, always use single direction with one to many relationships.
In order to tag only friday days just create a calculated column in date table like I did in the .pbix and just use it to filter the slicer.
