Using measure as a filter in table visual

[gvg]

Hi,

I am looking to figure out how to filter a text-only table with a measure. I have a table like this:

Employee            Division
-----------         ----------
Mike                Legal
John                IT
Peter               Legal
George              Sales

I want to show only Employees in "Legal" division if my measure evaluates to "Legal", The result should look like this:

Employee            Division
-----------         ----------
Mike                Legal
Peter               Legal

I need to do it with a measure since I want to calculate the filter value dynamically. Is there a way to do it?

Thanks.

[v-xulin-mstf · Accepted solution]

Hi @gvg,

Try measure as:

Measure = 
IF(
    MAX('Table'[Division])="Legal",
    1,
    0)

Here is the output:

Here is the demo, please try it.

Best Regards,

Link

[amitchandak]

@gvg , Try a measure like this

calculate(countrows(Table), filter(Table, Table[Division] ="Legal"))

But you can use a slicer for this, no need for a measure

[gvg]

@amitchandak ,thanks.

However I need to figure out how to make the whole thing work through a dynamic measure. I can not have dynamic slicer, can I? The measure in your example will only calculate the number of occurences, but not render the result I want, I am afraid.