Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Filtering from Slicer and Fixed Value

I have some data (table A) that can be assigned to a country or to all regions.  All the other data is country specific (table C, D etc...)

 

I have some visuals based on table A, table B and table C and a country slicer.

 

When I filter by country then the visuals filter based on the slicer.

 

However I want the Visual based in Table A to show All Regions, plus the filterd country. E.g. If I select USA, then Table A to filter for All data where country is "USA" and all data where country is "All Regions".

 

Is there a way to do this? 

 

Thanks

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    Anonymous , You need have common country table

     

    or create measure like this for table B and C

     

    calculate(sum(TableB[Value]), filter(TableB, TableB[Country] in values( TableA[Country])))

     

    or

     

    calculate(sum(TableB[Value]), keepfilter(Filter(TableB, TableB[Country] in values( TableA[Country]))) )