cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DieLem
Helper II
Helper II

Return Table with Filtered Values

Good Day,

I require a table to return certain unique values and as such Measures aren't successful. It seems trivial but I can't seem to get it right.

Data as such:

Name - Amount - Colour
Jimmy - 22 - Red
Steven - 35 - Red
Amanda - 40 - Red
John - 40 - Blue

I would like to filter the table with multiple criteria and return all the values in a table format. 
In this case I want all the Colour = Red and Amount > 30. Thus it should return:

Steven
Amanda

Thanks in advance!

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hey @DieLem

 

Could you just put all of your data in a table and then create slicers for Colour and Amount?

 

If you do want to create a new table with your criteria, try:

 

CALCULATETABLE(
    Table2,
    Table2[Colour] = "Red",
    Table2[Amount] > 30
)

You will get output that looks like this that you can just throw into a table.

 

PowerBIUpload.PNG

 

Hope this helps,

Parker

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hey @DieLem

 

Could you just put all of your data in a table and then create slicers for Colour and Amount?

 

If you do want to create a new table with your criteria, try:

 

CALCULATETABLE(
    Table2,
    Table2[Colour] = "Red",
    Table2[Amount] > 30
)

You will get output that looks like this that you can just throw into a table.

 

PowerBIUpload.PNG

 

Hope this helps,

Parker

View solution in original post

rajendran
Resident Rockstar
Resident Rockstar

Hi

 

In Modelling Tab, Select New Table and filter the extistin table as needed .

 

For Example:

 

New_Table= FILTER(Table_A, Table_A[COLOUR]="Red") // This works for single filter.

 

New_Table = CALCULATETABLE( Table_A, Table_A[COLOUR]="Red" , Table_A[Amt]>30) // As Stevens mentioned,this works for multifilter .

 

Thanks

Raj

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors