Measure % of # of VMI Orders =

var _allorders = CALCULATE([Count VMI Orders]+[Count ZEDI Orders]+[Count ZF2E Orders])
RETURN
CALCULATE(DIVIDE([Count VMI Orders],_allorders))

Measure % of VMI Invoiced Sales =

CALCULATE(DIVIDE([Total VMI Invoiced Value],[Total Invoiced Value]))

Measure % Of VMI Order Value =

CALCULATE(DIVIDE([Total VMI Order Value],[Total Order Value]))

Measure % of VMI Orders meeting FFA =

CALCULATE(DIVIDE([Count of VMI Orders Meeting FFA],[Count VMI Orders]))

Measure % of VMI Value =

var _allorders1 =
CALCULATE([Total ZEDI Order Value]+[Total ZF2E Order Value]+[Total VMI Order Value])

RETURN
CALCULATE(DIVIDE([Total VMI Order Value],_allorders1))

Measure▲ Cumulative VMI Order v. Run Rate =

[2024 Cumulative VMI Order Value]-[2024 Cumulative VMI Run Rate]

Measure 2024 Cumulative VMI Run Rate =

VAR CumulativeTotal =

CALCULATE(SUM('KEY-DAX-Calendar'[2024 Average VMI Daily Run Rate]),
FILTER(ALLSELECTED('KEY-DAX-Calendar'[Date]),'KEY-DAX-Calendar'[Date] <= MAX('KEY-DAX-Calendar'[Date])),'KEY-DAX-Calendar'[Date]>=DATE(2024,1,1))
RETURN
IF(ISBLANK([Total VMI Order Value]),BLANK(),CumulativeTotal)

Measure Total 2023 Potential VMI Order Value =

VAR ACTIVEVMIVALUE = CALCULATE(sum('FACT-Monthly SAP VA05'[Net value]),'KEY-Customer'[KEY-VMI.Status]="Active In VMI",'KEY-DAX-Calendar'[Year]="2023")

VAR INPROCESSVALUE = CALCULATE(SUM('FACT-Monthly SAP VA05'[Net value]),'KEY-Customer'[KEY-VMI.Status]="In Process",'KEY-DAX-Calendar'[Year]="2023")

RETURN

CALCULATE(ACTIVEVMIVALUE+INPROCESSVALUE)

TABLE Measure KEY-DAX-Calendar =

VAR BaseCalendar =

CALENDAR ( DATE ( 2019, 1, 1 ), TODAY())

RETURN

GENERATE (

    BaseCalendar,
    
    VAR BaseDate = [Date]
    
    Var DayNumber = WEEKDAY(BaseDate)
    
    VAR YearDate = YEAR ( BaseDate )
    
    VAR MonthNumber = MONTH ( BaseDate )
    
    VAR MonthName = FORMAT ( BaseDate, "mmmm" )
    
    VAR YearMonthName = FORMAT ( BaseDate, "mmm yy" )
    
    VAR YearMonthNumber = YearDate * 12 + MonthNumber - 1
    
    RETURN ROW (
    
        "Day", BaseDate,
        
        "Year", YearDate,
        
        "Month Number", MonthNumber,
        
        "Month", MonthName,
        
        "Year Month Number", YearMonthNumber,
        
        "Year Month", YearMonthName,
        
        "Year-Month",YearDate&" "& MonthName,
        
        "Week",WEEKNUM([Date]),
        
        "Day Number",DayNumber
    )
)

Measure Upper Boundary =

    SUMX('FACT-Monthly SAP VA05', 'FACT-Monthly SAP VA05'[FACT-Total and Average.Average Sales]+'FACT-Monthly SAP VA05'[Standard Deviation])