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

Anonymous — Fri, 13 Jul 2018 21:13:03 GMT

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.

topic Prior Year Sales by Category as a Percent of Total PY Sales in DAX Commands and Tips

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