Prior Year Sales by Category as a Percent of Total PY Sales

[Anonymous]

Hi,

I have a Measure that creates Prior Year Sales

Sales PY =
CALCULATE (
Order_Line_Invoice[SalesSUM],
SAMEPERIODLASTYEAR(Dates_INV[Date]))

I need to calculate the Sales by Category as a percent of Prior Year Sales. I can get the correct answer using a measure for current year.

My Percentage is > 100% using this formula:

Percentage Of Total PY = CALCULATE (
Order_Line_Invoice[SalesSUM],
SAMEPERIODLASTYEAR(Dates_INV[Date]))/CALCULATE(sum('Order_Line_Invoice' [Sales]),ALLSELECTED())

Is it the ALLSELECTED()?

I'll post it as Answerwed. Please help.