cancel
Showing results for
Did you mean:
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

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

Announcements