compare slicer selections with each row of the table

[Anonymous]

Dear all,

I have a Table with a Country-Column. The user should be able to select multiple countries in a slicer. I would then like to compare the selected options with each row in the table and return true if one of the selected countries corresponds to the country in the row.  Can you help me formulate this measure? 

I find it difficult to compare the selected values of the slicer with all rows in the same table.  Can I do this in a different way?

The problem is, that the country categories are not fixed, there might arise new countries, so a fixed table for the slicer would make no sense, right ?

Kind regards

Susanne 

[parry2k]

@Anonymous it is doable, can you share the sample data and expected output. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Anonymous]

Dear @parry2k ,

my table T has this structure:

id          year       profit         country

5          2020       10                USA

5          2019       50                USA

4          2020       100              Vietnam

4          2018       30                Vietnam

8         2019         25                France

Each id can have multiple entries, for different years and corresponding profits. The country value is on id level . 

The slicer in this case should show:

USA

Vietnam

France

where muliple selection should be possible. 

Next I would like to compare all selected values in the slicer with each row in T and if T[country] equals one of the selected slicer options, the measure should return true for this row, else false.

Note to the Slicer: I cannot create a fixed table for the slicer since there might arise new countries.

The only approach I have in mind is to import a dynamic table that is included into the refresh for the slicer.

But then I dont know how to formulate the measure since I cannot iterate over the specific categories 

e.g. if(T[Country]= "France") then true()

since we don't know all categories.

Kind regards

Susanne

[Anonymous · Accepted solution]

So create one table with country values.

Slicer= values(Table[Country])

This will create one table with all country values also if some country came later in future that time you just need to refresh the model.

Next step is You need add this column in Slicer(Multiselect enabled)

Create measure

MEasure=If(max(Table[Country]) in allselected(Slicer[COUNTRY]),TRUE,FALSE)

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

[Anonymous]

Awesome, thanks!