Forum Discussion
Help With Measure
I have a line chart (screenshot below) with two measures and I need help with the 2nd measure: %on-time - calculates the number of items that were delivered on time (green line chart below) %on-ti...
The Excel file shows the %on-time (normalisation applied) formula and the pbix file contains the replica formula in dax, also provided below. The purpose of the files (specifically Excel) is to provide context to the dax measure I'm having issues with.
%OnTime(Norm applied) = ([%OnTimeBox-Bulk]*[FinalDistBox-Bulk])+([%OnTimeUrban-Bulk]*[FinalDistUrban-Bulk])+([%OnTimeBox-Clearance]*[FinalDistBox-Clearance])+([%OnTimeUrban-Clearance]*[FinalDistUrban-Clearance])
It has been suggested to me to tag fellow super users to help with my issue if possible please. Any help is much appreciated. Thank you in advance mahoneypat , Fowmy , amitchandak , wdx223_Daniel