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

parry2k's avatar
parry2k
Super User
3 years ago

PowerBITestingG your question it not very clear, could you provide bit more context what you are trying to achieve and what the final output will be?

 

 

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.