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

Filter value field with corresponding number

Hi All, 

In the filter - what does the number next to the field mean?  So for example - looking at my region field what do the numbers next to blank and CAN mean? Random curiousity Smiley Happy

 

PBIquestion.JPG

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
MariaP Member
Member

Re: Filter value field with corresponding number

Hi @Kendraakaay ,

 

If you drag your columns into a table you will be able to see the number of rows for your selected Region Code. This will help you understand the numbers returned.

Example shown below: for the city Abbeville, there are 5 state_name records which yoiu can see in the filters.

As you filter counts change based on your data model relationships.

I do not know if you have any further filters applied which may be rsulting in counts that are not making sense to you.

 

Cheers,

Maria

 

FilterCount.PNG

4 REPLIES 4
MariaP Member
Member

Re: Filter value field with corresponding number

Hi @Kendraakaay 

 

The number is the toal number of records for CAN and Blanks, so you have 41 blanks and 10 CAN records

 

Maria

Kendraakaay Frequent Visitor
Frequent Visitor

Re: Filter value field with corresponding number

@MariaP  Thanks for your reply but I don't think that's correct.  Unless I misunderstand what you mean by record... what do you mean by record?  The numbers do not at all seem to correspond to the amount of rows for each attribute. 

MariaP Member
Member

Re: Filter value field with corresponding number

Hi @Kendraakaay ,

 

If you drag your columns into a table you will be able to see the number of rows for your selected Region Code. This will help you understand the numbers returned.

Example shown below: for the city Abbeville, there are 5 state_name records which yoiu can see in the filters.

As you filter counts change based on your data model relationships.

I do not know if you have any further filters applied which may be rsulting in counts that are not making sense to you.

 

Cheers,

Maria

 

FilterCount.PNG

Kendraakaay Frequent Visitor
Frequent Visitor

Re: Filter value field with corresponding number

thank you @MariaP .  The data I am looking at shows surprising amount of records - for example a region we don't use very often has a count 4x as high as one that we do.  But your explanation makes sense.