Calculation with Slicer selection.

[Decter3343]

Hi. 

below is my request. i have been tried several way. but it was not working. 

1. Table1 has dozens of product name columns like A, B, C, and D. And there is a column the  region of production 
2. I will Select Region for Slicer1.
3. When I select a specific product in Slicer1, I want to assign 10 points to that product and 5 points to the others.
4. i will show point status in the chart.

I can't implement it well with the if function. If there is a way, I'd appreciate it if you let me know.

thanks in advanced

[Manokamna · Accepted solution]

Create a new measure using Swtich 

[Decter3343]

thans for response. but i have a question.

Do you mean that if there are 100 regions, each region should be reflected in the functional equation?
Then it is required to make 10,000 if functions in the formula. (100 x 100 = 10,000)