show me names of people after certain filter is applied

[schoden]

Hi, 

I want to show company name and created by person , with filter of country set to particular.

My code like 

Show= Calculate(values(table[company_name]) && values(table[created by])),  country="UK"

[schoden · Accepted solution]

hi @amitchandak , 

Thanks for the reply but I do not want to count the row.  I want to show the STRING value -company and person created name as it is not integer. 

measure = Calculate(MAX( table[country-name]), country="UK"

I found the solution 😄 

[amitchandak]

@schoden 

You can create a column like

New name =(table[company_name]) & (table[created by])

You can use the filter at the visual level or use slicer or create a measure with filter

Measure = calculate(count(Table[New name]),country="UK")

You can use this measure with New Name , in table or matrix or visual , that will filter

[schoden · Accepted solution]

hi @amitchandak , 

Thanks for the reply but I do not want to count the row.  I want to show the STRING value -company and person created name as it is not integer. 

measure = Calculate(MAX( table[country-name]), country="UK"

I found the solution 😄 

[v-eachen-msft · Accepted solution]

Hi @schoden ,

I am glad that you have solved it by yourself, you could accept your own reply.