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
DavidWaters100Post Patron
Post PatronHi Mariusz - your measure works if I change it to top 4 only. But the problem is that I have to specify top ten - in most cases (when report filters are applied) there will be a full top ten but in some cases there are less than 10. In cases less than 10, the measure still returns a full top 10 for last year. Can the TopN be dynamic if the number if the number of types is less than ten? I think that will solve it?
Mariusz
Community Champion
Community Champion
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
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.