Forum Discussion
DavidWaters100
Post Patron
Post PatronPrevious year values for current top 10
Hi, I am running below measure to return top 10 values for the current year. I also need to return the values of the previous year - but for the same top 10 in current year. I can't seem to ...
Try if this works for you.
Measure = VAR __selection = ALLSELECTED( 'Product'[ColorName] ) VAR __countSelection = COUNTROWS( __selection ) VAR __logical = IF( __countSelection > 10, 10, __countSelection ) VAR __topN = TOPN( __logical, __selection, [Sales Amount], DESC ) RETURN CALCULATE( [Sales Amount], KEEPFILTERS( __topN ), SAMEPERIODLASTYEAR( 'Date'[Datekey] ) )Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn
mahoneypat
Microsoft Employee
Microsoft EmployeePlease try this approach instead:
Top 10 Brokers = var ranking = values(BrokerNames[Short Name])
var top10CY = calculatetable(values(BrokerNames[Short Name]),TOPN(10,BrokerNames,[Current Year Amount]),ranking)
return calculate([Prev Year Amount], top10CY)
This assume you already have a Prev Year Amount measure.
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat