How to count the number of rows after the filter is applied (not distinctcount)

[kimlien3006]

Hi everybody, 

I have a dataset including columns of region, country and  sales. What I want to create is a filter based on region and a chart/card which shows the number of sales and the number of countries according to region. The chart/card need to be dynamic and changed when I change the filter of region. Do you know any measures which can solve this? 

Many thanks!

[Sumanth_23 · Accepted solution]

hi @kimlien3006 - You can achieve this by creating a measure for Sales and Count of rows - please see screen grabs of how you can implement the same. 

Total Sales = SUM('Region Country Sales'[Sales])

Rows Count = COUNTROWS('Region Country Sales')

Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!

[kimlien3006]

Thanks a lot! It works well. 

[Sumanth_23]

hi @kimlien3006 - Happy to help! 

[DebbieE]

Ill have a go

I set up a dataset

then Created two measures

No of Countries in Region = DISTINCTCOUNT('Table'[County]) (Whoops called it county instead of country)

Number of Sales = SUM('Table'[Sales])

And added a filter and the two cards

Im guessing Im off the mark on this one because its quite a simple solution but I think it answers your question on the number of sales and the number of countries according to region

[kimlien3006]

Hi @DebbieE  thanks a lot! I also tried your solution. It also works well.

[DebbieE]

🙂 I realised you post header specified to not use DISTINCTCOUNT. Apologies.  I went straight in for a DISTINCTCOUNT measure

[jthomson]

Why wouldn't you just use countrows in the first instance and sum([sales]) in the second instance?