cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Periksson
Frequent Visitor

Dynamic TOPN problem default value

Ok, so I'm struggling for a few days already to dynamically select top N of my Goods table. The problem is not for selecting top N, but the default value when none is selected. I want it to give me the whole table of Goods when none of N is selected, that is when All is selected on the slicer. I've imitated the steps for the succesful implementation of topN that can be found on many how to videos and tutorials that are very similar or the same.

Here are my measures:

Goods Rank = RANKX(ALL(Goods); [Profit]) 

Profit Top N Goods = CALCULATE([Profit]; TOPN([Selected N]; Goods; [Profit]; DESC; Goods[ID]))

Selected N = SELECTEDVALUE('TopNGoods'[Select N]; COUNTROWS(Goods))

Goods Rank within Selected N = IF([Goods Rank] <= [Selected N]; 1; 0)

The problem is in the Selected N measure specifically if I'm not wrong. When none is selected the measure gives me back 1. So the default value of that measure is 1. And my default value should be the measure of COUNTROWS(Goods). That table doesn't have only one row, but multiple, and it gives me back value 1 when i test it in a table. How is that even remotely possible? What am I doing wrong here?

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Selected N = SELECTEDVALUE('TopNGoods'[Select N]; COUNTROWS(ALL(Goods)))

But I think you should just create measure(s) with some SWITCH logic.

 

Best

Darek

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Selected N = SELECTEDVALUE('TopNGoods'[Select N]; COUNTROWS(ALL(Goods)))

But I think you should just create measure(s) with some SWITCH logic.

 

Best

Darek

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors