Dynamic table based on selected value

[Anonymous]

I've slicer period: data like Month-year 

I've created a table

Param = {

("NBI Adjusted Calendar 2 " , NAMEOF('Fact Performance Indicators'[NBI Adjusted]), 0,"NBI Adjusted","Net Banking Income",0),

("NBI Adjusted Calendar 2", NAMEOF('Fact Performance Indicators'[NBI Adjusted 2]), 1,"NBI Adjusted","Net Banking Income",1))

I'd like to display "NBI Adjusted" selectedvalue(period), but it dosen't work,it always return NBI adjusted and not NBI adjusted Oct-2022, how can I change it please?

[AlexisOlson]

@amitchandak is correct. Calculated tables cannot be dynamically responsive to slicers since they are only computed once each time the data model is loaded or refreshed and not in response to user interactions via filters/slicers/cross-filtering.

There may be ways to accomplish the effect you're after but you'll need a different approach (I can't tell what you're asking well enough to suggest something specific though).

[Anonymous]

@AlexisOlson Could you please help me to resolve it? I use field parameter. 

[amitchandak]

@Anonymous , A table can not take slicer value. Only a table in var of measure can take

You can think of dynamic segmentation if needed

example

Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://www.youtube.com/watch?v=W4EF1f_k6iY

[Anonymous]

I don't think so..