Trying to figure ou a SWITCH for a calculated column

[Anonymous]

Here is my structure.

Here is my "setup varejista" table

What I am trying to do :

Create a calculated column ("N5MP") in my product table that checks the setup varejista[#N] and calculates the field based on its value. And here is my product table structure:

Here is what I came up with so far, but it does not work. it always returns the else case of the switch

Filtro N5MP = VAR catmax = SELECTEDVALUE('Setup Varejista'[#N]) RETURN

SWITCH(catmax,

1,

(IF(

CALCULATE([Venda MP],ALLEXCEPT(Produto,Produto[N1]))>0,

"1",

"0")),

2,

(IF(

CALCULATE([Venda MP],ALLEXCEPT(Produto,Produto[N2]))>0,

"1",

"0")),

3,

(IF(

CALCULATE([Venda MP],ALLEXCEPT(Produto,Produto[N3]))>0,

"1",

"0")),

4,

(IF(

CALCULATE([Venda MP],ALLEXCEPT(Produto,Produto[N4]))>0,

"1",

"0")),

"Rever mercadológico"

)

Not sure aboute the variable setting, not very good with DAX, because of the data structure I cannot acces the  "setup varejista" from the product table in order to do the calculation, So i tought agoint checking it some other way and then bringing that value to my table...

What am I doing wrong/ how do I do this?

[PaulDBrown]

@Anonymous 

The problem is that there is no context for the SELECTEDVALUE expression (so it sees no value). 

Why do you need this as a Calculated column? You could easily do the calculation in a measure for a visual.