Forum Discussion

Thigs's avatar
Thigs
Helper IV
4 years ago
Solved

SKU Distribution Trend?

Hi all! I'm working with a client with about 4,000 SKUs in a given year. However, it is a very seasonal business, so only about 1,500 SKUs are in store at any given time. What I need to know is how ...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Thigs 

    This is only part of the complete measure

    Matching Percent =
VAR CurrentSKUs =
    VALUES ( 'SKU Distributions'[SKU] )
VAR PreviousSKUs =
    CALCULATETABLE (
        VALUES ( 'SKU Distributions'[SKU] ),
        'SKU Distributions'[Date Only]
            = MAX ( 'SKU Distributions'[Date Only] ) - 1
    )
RETURN
    COUNTROWS ( INTERSECT ( PreviousSKUs, CurrentSKUs ) )
tamerj1's avatar
tamerj1
Community Champion
4 years ago

You missed the COUNTROWS of "PreviousSKUs 

Thigs's avatar
Thigs
Helper IV
4 years ago

Like this?

Matching Percent 2 =
VAR CurrentSKUs =
VALUES ( 'SKU Distributions'[SKU] )
VAR PreviousSKUs =
CALCULATETABLE (
VALUES ( 'SKU Distributions'[SKU] ),
'SKU Distributions'[Date Only]
= MAX ( 'SKU Distributions'[Date Only] ) - 1
)

VAR NumRows = COUNTROWS ( INTERSECT ( PreviousSKUs, CurrentSKUs ) )
RETURN
DIVIDE(NumRows, COUNTROWS(PreviousSKUs))
 
It just returns "1" for everything....
  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    Can you share a screenshot?