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
AlB's avatar
AlB
Community Champion
5 years ago

Anonymous 

The 0.25 is just because there are four. It doesn't have to do with Clearance or bulk. I'm just saying if [%on-time] is built of those 4 components with equal weight for each of them, then it should be able to be calculated  as

([%OnTimeBox-Bulk])+([%OnTimeUrban-Bulk])+([%OnTimeBox-Clearance])+([%OnTimeUrban-Clearance]))*0.25

where the 0.25 is the equal wight for all four of them

I'm trying to see if there's an inconsistency in the results there

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

    AlB  i see what you mean now and sorry for the confusion. The weightings are based on the Final Distribution table (included in initial post). Hope that helps clarify..