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

whats the formula for your first measure??

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Anonymous 

    %OnTime = [TotalOnTime]/[TotalAccep&DelScan]

[TotalOnTime] = CALCULATE(COUNTROWS('DistProfile v1-3'),FILTER('DistProfile v1-3','DistProfile v1-3'[Acceptance]<>BLANK()&&'DistProfile v1-3'[Delivery]<>BLANK()&&'DistProfile v1-3'[On Time]="Y"))

[TotalAccep&DelScan] = CALCULATE(COUNTROWS(FILTER('DistProfile v1-3','DistProfile v1-3'[Delivery]<>BLANK()&&'DistProfile v1-3'[Acceptance]<>BLANK()&&'DistProfile v1-3'[On Time]<>"Err Scan"&&'DistProfile v1-3'[On Time]<>"No Scan")))