cancel
Showing results for
Did you mean:
Highlighted
Regular Visitor

## Count Distinct Items Ranked Less than 5

Hello,

I have a project where I need to count the number of items where the Rank is less than or equal to 5.

Using RANKX I created a ranking for each item, but for the life of me have not been able to figure out how to count the item numbers that rank less than or equal to 5.

Below in the Rank <5 field is my desired effect if it can be achived.

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
New Contributor

## Re: Count Distinct Items Ranked Less than 5

Hi @DarylM ,

You can try the following measure:

```item #'s less than or equal to 5 =
VAR __rank =
ADDCOLUMNS ( 'Table', "rank", [Rankx Measure] )
RETURN
CALCULATE ( DISTINCTCOUNT ( 'Table'[Item #] ), FILTER ( __rank, [rank] <= 5 ) )```

Results are as follows:

Here is a demo, you can try it:

https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EUUOKDmzbrdFt6VWPB...

Best Regards,

Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 REPLIES 3
Super User III

## Re: Count Distinct Items Ranked Less than 5

Hi @DarylM

If 'Rank<5'  is a calculated column you could place this measure in a card visual:

```Measure =
CALCULATE ( DISTINCTCOUNT ( Table1[Item #] ), Table1[Item #] <= 5 )```

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers

Regular Visitor

## Re: Count Distinct Items Ranked Less than 5

Hi Thanks!

The example I just created in Excel to show what I am looking for. The RANKX is a measure in Power BI and I a trying to create a measure that will count the item #'s less than or equal to 5.

New Contributor

## Re: Count Distinct Items Ranked Less than 5

Hi @DarylM ,

You can try the following measure:

```item #'s less than or equal to 5 =
VAR __rank =
ADDCOLUMNS ( 'Table', "rank", [Rankx Measure] )
RETURN
CALCULATE ( DISTINCTCOUNT ( 'Table'[Item #] ), FILTER ( __rank, [rank] <= 5 ) )```

Results are as follows:

Here is a demo, you can try it:

https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EUUOKDmzbrdFt6VWPB...

Best Regards,

Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements