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 - ColourJimmy - 22 - RedSteven - 35 - RedAmanda - 40 - RedJohn - 40 - BlueI 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:StevenAmandaThanks in advance!
Go to Solution.
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:
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,
View solution in original post
In Modelling Tab, Select New Table and filter the extistin table as needed .
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 .
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.