Select the sum column based on the filter value in another table.

[Anonymous]

hi, this is my scenario:

table: FilterValue

FilterValue = {"Sales","Profits"}

Table: Values

M=

var _v= IF(HASONEFILTER(FilterValue[Value]),

SWITCH(SELECTEDVALUE(FilterValue[Value]),

"Sales", Values[SumSales],

"Profits", Values[SumProfits]

),

BLANK()

)

return _v

but the formula returns blank always. The two tables has not relations

[Anonymous · Accepted solution]

thanks amitchandak

I Solve creating a new column with one value of the filter, later, add the relations to this column. Without the relationship, the filter don't work

[amitchandak]

@Anonymous , This seem fine

Try line

SWITCH(SELECTEDVALUE(FilterValue[Value],"Sales"),

"Sales", Values[SumSales],

"Profits", Values[SumProfits]

)

My advice would be to explore field parameters

Field Parameters- One solution for Measure Dimension slicer: https://youtu.be/lqF3Wa1FllE?t=70