Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi AlB , here is link to folder that contains both the pbix and Excel file.

 

AlB's avatar
AlB
Community Champion
5 years ago

Anonymous 

What exactly would you like me to do with those files?

 

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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])

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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