Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Return a Table With a SWITCH

hi, I have the following table: "COSTORCOUNT" and a parameter table:  "parameterTable"   I'm tring to return a table according to selectedvalue from the "parameterTable" I put the pa...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    Anonymous I've never had any luck with DAX being able to return one table or another table. It doesn't like it. Try this instead:

    dynamicSlicer = 
    VAR _Selected = SELECTEDVALUE(parameterTable[parameter])
    VAR _Table = SUMMARIZE(FILTER(COSTORCOUNT, [Flag] = _Selected),[Flag])
RETURN
    _Table
ant_lah's avatar
ant_lah
Frequent Visitor
1 year ago

Hello,

I'm dealing with a similar situation, but can't get the solution to work.

I want to filter a table based on a slicer selection, but whenever I put SELECTEDVALUE in the filter condition, the resulting table is blank no matter what slicer button I click.

leased =
    VAR _Selected = SELECTEDVALUE('Farm sizes and numbers'[Category of holdings])
    VAR _Table = SUMMARIZE(FILTER('Farm sizes and numbers', [Category of holdings] = _Selected),'Farm sizes and numbers'[State],'Farm sizes and numbers'[District], 
"number leased", SUM('Farm sizes and numbers'[Wholly leased-in holdings]), 
"area leased",SUM('Farm sizes and numbers'[Area of wholly leased-in holdings]))
RETURN
    _Table

If I substitute a string value for _Selected in the filter, say "Medium", everything works fine, but I need to manipulate the table dynamically rather than just set the condition in the DAX expression.

 

And if someone knows of a way to get this to work with multiple slicer selections (say, to allow both "Medium" and "Large" values of {Category of holdings], that would be magical.

 

Thank you!