How to filter report using measure or distinct count formula on column

[michael95677]

I am fairly new to Power BI and loaded a query to build various reports from. The query loaded fine. However, I'm trying to filter the table by only showing rows based on a count of < 3 on a column included in the query/table. I've tried a measure using Calculate and distinctcount but always get errors: 

Measure = ActionsItemsCount

CALCULATE(

DISTINCTCOUNT('Referrals'[seq_no]),

FILTER('Referrals'[seq_no] < 3))

I've also tried adding a data field as a column using 

CountActionItems = distinctcount(Referrals[seq_no]) < 3

and this seems to work but I do not know how to use it as a filter in the report. Any help is greatly appreciated. 

[Jihwan_Kim · Accepted solution]

Hi,

Please try the below.

ActionsItemsCount =
CALCULATE (
DISTINCTCOUNT ( 'Referrals'[seq_no] ),
FILTER ( 'Referrals', 'Referrals'[seq_no] < 3 )
)

[michael95677]

Ahhh, I forgot the second table reference. Thank you so much. Now if I could just figure out how to actually apply this measure to the report output that would be great.