How to filter all rows of column except one row/one name?

[Anonymous]

I want to filter a field(WorkerName) of Worker table but exclude only one name "Once Off".

[v-stephen-msft · Accepted solution]

Hi @Anonymous ,

You can filter in desktop or power query editor.

In the power bi desktop, you can add a visualization filter, page filter, or report filter to a report in Power BI.

In the power query editor, you can do the following. Click the triangle button next to the field name, and then filter.

 

Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-report-add-filter

                  https://www.iscorp.biz/power-bi-filtering-your-data/

Best Regards,

Stephen Tao

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

[v-stephen-msft · Accepted solution]

Hi @Anonymous ,

You can filter in desktop or power query editor.

In the power bi desktop, you can add a visualization filter, page filter, or report filter to a report in Power BI.

In the power query editor, you can do the following. Click the triangle button next to the field name, and then filter.

 

Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-report-add-filter

                  https://www.iscorp.biz/power-bi-filtering-your-data/

Best Regards,

Stephen Tao

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

[amitchandak]

@Anonymous , You can create a measure

countrows(Filter(Table, Table[WorkerName] <> "Once Off"))

[Anonymous]

Thanks for quick reply but I don't want count but all names

[amitchandak]

@Anonymous , Plot the name with the measure in a table visual you will get those

Or plot name in visual and use visual level filter for measure is not blank

[Anonymous]

[Anonymous]

WorkerName = FILTER ( VALUES ( Worker[WorkerName] ), Worker[WorkerName] = "Once Off" )

Now I want all names except Once Off

[Anonymous · Accepted solution]

CALCULATE(

SUM(InvoiceLines[Tons]),

FILTER(InvoiceLines, InvoiceLines[ITEMID] = InventoryStock[ITEMID]),

Filter(Worker, Worker[WORKERNAME] <> "Once Off")

)