Problem with set analys - Variable

[bruno_silva100]

Hey Guys, I have a problem with set analysis. I tried much forms, but i didn't get the result, only when i use the if.

worked

sum(if($(vPeriodoFiltro)=1,[Quantidade Vendida])) 

not worked

sum( {$ <'=$(vPeriodoFiltro)'={"1"} >}[Quantidade Vendida]) -

sum( {$ <vPeriodoFiltro={"1"} >}[Quantidade Vendida])

sum( {$ <vPeriodoFiltro={'1'} >}[Quantidade Vendida])

sum( {$ <$(vPeriodoFiltro)={'1'} >}[Quantidade Vendida])

Anybody know the form correct ?

[kaushiknsolanki · Accepted solution]

HI,

In your scenario, set analysis wont help, because for set analysis to work, you need a field name as Set identifier.

It can not take Variable as Set Identifier.

So your original expression is the only way to get this work.

Regards,

Kaushik Solanki

[bruno_silva100]

Tks @kaushiknsolanki . I go to use the first expression.