Calculate Count of Customers when TopN Filter Changes

[michellem0771]

Hello,

I'm hoping someone can help with this.

I have a report that lists Client, Revenue and Rank.

I also have several filters in the filter pane along with a filter to show TopN that may change from 10 to 100 in increments of 5.

Next to the list of client information, I have a summary that shows total revenue and client count.

Everything filters fine when I use the filters on the filters pane, however, when I choose a different "TopN" number, the Client Count and the Total Rev amount to not update to show the numbers, they stay the same.  I'd like to see that where the TopN Filter Selection changes as shown below, the count and revenue numbers update as well.

I have done many searches, and perhaps I am not wording my questions correctly, but I have been unable to find anything helpful.

Is what I am looking to do possible?

Thanks for any help you can provide!

[Ashish_Mathur · Accepted solution]

Hi,

You will have to create a disconnected table (named TopN with a single column called number) with numbers ranging from 1-5.  Create a slicer and select 3 there.  Write these measures

Selected Top n value = selectedvalue(Topn[Number])

Revenue from Top n customers = sumx(topn([Selected Top n value],values(Data[Customer]),[Revenue]),[Revenue])

Hope this helps.

[michellem0771]

This worked great, thank you so much!

[Ashish_Mathur]

You are welcome.

[vanessafvg]

are you able to share your data?  and can you give an example of what you expect the output to be.

If you cannot share your data please provide some sample data in text format.