Forum Discussion

PowerBITestingG's avatar
PowerBITestingG
Resolver I
3 years ago
Solved

User input for table

I basically want a table like this:   Country (100 countries) Amount Antigua and Barbuda   ...   Zimbabwe     Where I can input custom values in amount that will be used for my...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    3 years ago

    Hi, PowerBITestingG 

    Please use 'in values' to replace 'selectedvalue' like:

    Measure = IF(MAX(Table[Country]) in VALUES(SlicerTable[Country]),1,0)

     

    Best Regards,
    Community Support Team _ Eason

v-easonf-msft's avatar
v-easonf-msft
Community Support
3 years ago

Hi, PowerBITestingG 

Please use 'in values' to replace 'selectedvalue' like:

Measure = IF(MAX(Table[Country]) in VALUES(SlicerTable[Country]),1,0)

 

Best Regards,
Community Support Team _ Eason