Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
thomas_coltrain
Frequent Visitor

Help filtering data out of a table field

Hey,

I am having issues getting the correct filter command right..Here is what I am trying to do

 

Say we have the Table "Orders" and in that table is a SubStatus Field that has 5 values

So it would be 'Orders'[SubStatus]

The SubStatus values are

1

2

3

4

5

 

So I need a new column for Orders pulling from SubStatus that only shows the SubStatus 1,2,3 in that column

 

So in table form here is how it would look

     

 

                Filter SubStatus Column

Orders            1

                       3

                       2

                       1 etc. (only filtering out 1 , 2 , 3 and leaving out the 4, 5)

 

Let me know if any more information is needed

Thanks,

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @thomas_coltrain,

You can set a filter on the visual subcolumn fields to exclude the value that is larger than 4.

Regards,

Xiaoxin Sheng

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi @thomas_coltrain,

You can set a filter on the visual subcolumn fields to exclude the value that is larger than 4.

Regards,

Xiaoxin Sheng

lukiz84
Memorable Member
Memorable Member

Do you want to use the filtered data in a measure? Because you talk of column, I don't really get it.

 

Anyway, in a measure the filter would be

 

YourMeasure =
CALCULATE(yourLogic, FILTER(Orders, Orders[SubStatus] < 4))

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.