PODs All Time

This measure disregards the date picker entirely, relying only on applied filters, including time-based filters.

Formula

m₁ / m₂
with:
m₁ = Distinct Count([Depletions].[Aggregate Item Name])
    WHERE
        [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
m₂ = Distinct Count([Depletions].[Outlet Eid])
    WHERE
        [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'

Additional Details

Output Format: #,##0
Created: 2024-10-26T17:51:32Z
Last Updated: 2024-11-14T18:54:34Z
Key: [calculation].[PODs All Time]

PODs MTD

Formula

m₁ / m₂
with:
m₁ = Distinct Count([Depletions].[Aggregate Item Name])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Month in Current Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Current Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
m₂ = Distinct Count([Depletions].[Outlet Eid])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Month in Current Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Current Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'

PODs MTD LY

Formula

m₁ / m₂
with:
m₁ = Distinct Count([Depletions].[Aggregate Item Name])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Month in Previous Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Previous Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
m₂ = Distinct Count([Depletions].[Outlet Eid])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Month in Previous Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Previous Period'
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'

PODs MTD Δ

Formula

(m₁ / m₂) - (m₃ / m₄)
with:
m₁ = Distinct Count([Depletions].[Aggregate Item Name])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Month in Current Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Current Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
m₂ = Distinct Count([Depletions].[Outlet Eid])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Month in Current Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Current Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
m₃ = Distinct Count([Depletions].[Aggregate Item Name])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Month in Previous Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Previous Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
m₄ = Distinct Count([Depletions].[Outlet Eid])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Month in Previous Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Previous Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'

PODs MTD Δ%

Formula

(m₁ / m₂) / (m₃ / m₄) - 1
with:
m₁ = Distinct Count([Depletions].[Aggregate Item Name])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Month in Current Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Current Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
m₂ = Distinct Count([Depletions].[Outlet Eid])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Month in Current Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Current Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
m₃ = Distinct Count([Depletions].[Aggregate Item Name])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Month in Previous Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Previous Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
m₄ = Distinct Count([Depletions].[Outlet Eid])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Month in Previous Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Previous Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'

PODs YDAY

Formula

m₁ / m₂
with:
m₁ = Distinct Count([Depletions].[Aggregate Item Name])
    WHERE
        [Depletions].[Invoice Date] = 'End of Current Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
m₂ = Distinct Count([Depletions].[Outlet Eid])
    WHERE
        [Depletions].[Invoice Date] = 'End of Current Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'

PODs YTD

Formula

m₁ / m₂
with:
m₁ = Distinct Count([Depletions].[Aggregate Item Name])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Year in Current Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Current Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
m₂ = Distinct Count([Depletions].[Outlet Eid])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Year in Current Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Current Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'

PODs YTD LY

Formula

m₁ / m₂
with:
m₁ = Distinct Count([Depletions].[Aggregate Item Name])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Year in Previous Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Previous Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
m₂ = Distinct Count([Depletions].[Outlet Eid])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Year in Previous Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Previous Period'
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'

PODs YTD Δ

Formula

(m₁ / m₂) - (m₃ / m₄)
with:
m₁ = Distinct Count([Depletions].[Aggregate Item Name])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Year in Current Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Current Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
m₂ = Distinct Count([Depletions].[Outlet Eid])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Year in Current Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Current Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
m₃ = Distinct Count([Depletions].[Aggregate Item Name])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Year in Previous Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Previous Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
m₄ = Distinct Count([Depletions].[Outlet Eid])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Year in Previous Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Previous Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'

PODs YTD Δ%

Formula

(m₁ / m₂) / (m₃ / m₄) - 1
with:
m₁ = Distinct Count([Depletions].[Aggregate Item Name])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Year in Current Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Current Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
m₂ = Distinct Count([Depletions].[Outlet Eid])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Year in Current Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Current Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
m₃ = Distinct Count([Depletions].[Aggregate Item Name])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Year in Previous Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Previous Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
m₄ = Distinct Count([Depletions].[Outlet Eid])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Year in Previous Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Previous Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'