Delivery Reconciliation Measures (WIP)

 

RELATIONSHIPS:

'Unit'.[UnitNumber] (1) --> 'Delivery Order Cash Recon'.Unit (many)

MEASURES:

[Active Unit Count] = 

VAR Units =

DISTINCTCOUNT(

    'Delivery Order Cash Recon'[Unit]

)

RETURN 

IF(

    ISBLANK(Units),

    0,

    Units

)

3, "Active Units"

---------------------------------------

[Delivery Sales] = 

SUM('Delivery Order Cash Recon'[Sales])

---------------------------------------

[Average Unit Sales] = 

DIVIDE ([Delivery Sales], [Active Unit Count])

4, 'Average Sales"

 

---------------------------------------

[Transaction Count] =

COUNTROWS ('Delivery Order Cash Recon')

---------------------------------------

[Average Check Sales] =

DIVIDE ([Delivery Sales], [Transaction Count])

5, "Average Check"

---------------------------------------

[Active Unit Measures] =

VAR MetricTypeFlagItem = SELECTEDVALUE(MetricTypeFlag[MetricTypeFlag])

VAR SelectedMeasure =

    SWITCH(MetricTypeFlagItem

    ,3,[Active Unit Count]

    ,4,[Average Unit Sales]

    ,5,[Average Check Sales]

    )

RETURN SelectedMeasure 

[DoordashActiveUnits] =

CALCULATE(

    [Active Unit Count],

    'Delivery Order Cash Recon'[Delivery Vendor (DSP)] = "Doordash"

)