display one dimension based on other dimension in table visual

[rohtashgoyal]

My data is like that in table(visual) 

Representative, country, agent_type, sale

for each row, I need to display country for agent_type="supervisor"

all dimension have their own dimension table, joined with fact table using 1 to many relationship.

I want to do it by creating dax measure, not calculated column.

Thanks

[rohtashgoyal]

Hi @amitchandak, I don't need sale value here, I need to create measure to update Representative name, I want to show representative name from country India, in other rows as well, where country is not India.

Thanks

[Icey]

Hi @rohtashgoyal ,

Could you create a specific example? 

Reference: How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,

Icey

[amitchandak]

@rohtashgoyal , Either slicer should filter or measure can use filter

example

calculate(sum(Sales[sales]), filter(Country, country[agent_type]="supervisor" ) )