Filter a Table Using a Measure

[Anonymous]

I am trying to filter a table using a measure. Basically I want to filter and retain only those values where the 'Table'[Task Current Milestone Status ] = "Ongoing".

I've tried: Filter Tasks Open 1 = FILTER ('Table',[Task Current Status] = "Ongoing")

I keep getting an error as seen in the picture below. Thus, the final table should only have 3 rows at the end, where the [Task Current Milestone Status] = "Ongoing".

How can I achieve this result? You can also download the file with the link below. https://drive.google.com/file/d/1EBEiYfVwfdTX7R8hJcrG1TzoZ3N_rljH/view?usp=sharing

[v-alq-msft]

Hi, @Anonymous 

If you take the answer of someone, please mark it as the solution to help the other member0s who have same problems find it more quickly. If not, let me know and I'll try to help you further. Thanks.

Best Regards

Allan

[v-alq-msft]

Hi, @Anonymous 

A calculated column or a measure will return a scalar value. While Filter() function return a table that represents a subset of another table or expression. I'd like to suggest you create a calculated table with the following dax. The pbix file is attached in the end.

NewTable = FILTER ('Table',[Task Current Status] = "Ongoing")

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Fowmy]

@Anonymous 

FILTER returns a table, you cannot return a table using a measure, if you need to count the rows for example then you can use like

Measure Name =  COUNTROWS(FILTER ('Table',[Task Current Status] = "Ongoing"))

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn