Count of Unique Values Sold Each Day Based on Sales to Date + Running Total

[paulsnet1986]

I am badly in need of a measure in to take the data in Table 1 and represent it as displayed in table two. Essentially I need a measure that counts sales only when the sale is of an SKU that hasn't already been sold in a prior date in the table, and then a running total of the first measure. Completely lost, any help would be greatly appreciated. Thank you.

Table 1

Table 2

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

Unique SKU sales: =

VAR currentdate =

MAX ( Data[Date] )

VAR previousSKU =

CALCULATETABLE (

VALUES ( Data[SKU] ),

FILTER ( ALL ( Data ), Data[Date] < currentdate )

)

VAR currentSKU =

VALUES ( Data[SKU] )

VAR onlycurrentdateSKU =

EXCEPT ( currentSKU, previousSKU )

RETURN

IF ( HASONEVALUE ( Data[Date] ), COUNTROWS ( onlycurrentdateSKU ) + 0 )

Unique SKUs running total: =

VAR currentdate =

MAX ( Data[Date] )

RETURN

IF (

HASONEVALUE ( Data[Date] ),

CALCULATE (

COUNTROWS ( VALUES ( Data[SKU] ) ),

FILTER ( ALL ( Data ), Data[Date] <= currentdate )

)

)

[paulsnet1986]

Beautiful, thank you so much!