Return Table with Filtered Values

[DieLem]

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!

[Anonymous · Accepted solution]

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.

Hope this helps,

Parker

[Anonymous]

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