Table selection

[RajK2]

Hi

I've FACT Table like columns Period, Desc, Mention, List, amount

Filters : Period, Mention

Hence I have build summarized table with standard fields.

Desc, Amount

if I choose 'mention' in the filter then result: 

Desc,Mention,Amount... incase uncheck filters then go out from table like versa... 

please guide dax code on this

[v-prasare]

Hi @RajK2,

thanks for explaining the scenario. To better understand the issue and provide an accurate solution, could you please share a small set of sample data (with any sensitive information removed) along with the expected output? This will help ensure the guidance is aligned with your exact requirement.

Thanks,

Prashanth

MS fabric community support

[v-prasare · Accepted solution]

Hi @RajK2,

thanks for explaining the scenario. To better understand the issue and provide an accurate solution, could you please share a small set of sample data (with any sensitive information removed) along with the expected output? This will help ensure the guidance is aligned with your exact requirement.

Thanks,

Prashanth

MS fabric community support

[danextian]

If by summarized table you are referring to a calculated summary table, it does not respond to slicer selections. Calculated tables are only updated during refresh, or when the referenced tables, columns, measures, or the formula itself are modified. There is no DAX that allows calculated tables to be dynamically filtered by slicer selections.

[RajK2]

Let me explain

Parameter = {
("Goodwill", NAMEOF('Sales_Data'[Desc]), 0),
("Revenue", NAMEOF('_Sales_Data'[Amount2]), 1),
("Debt", NAMEOF('_Sales_Data'[Amount3]), 3),
("Rent", NAMEOF('_Sales_Data'[Amount4]), 2)}

This is parameter I used in the table and the same I filtered selection

Quarter, Country, Parameter
(bold highlighed above standard columns and parameter only dynamic)

if I filter 'Goodwill' then Goodwill will in the table OR 'Rent' select then 'Rent' will show in the table along with Quarter, Country.

My question if unselect ALL filters (parameter) then
Result

Quarter, Country, Goodwill,Revenue,Debt,Rent

Should be Result
Quarter, Country

how to avoid this. / disable unselected fields in the parameter like any code..

[alish_b]

Hi @RajK2 ,

I am not sure if I understand the problem at hand. Could you please provide sample data (without any sensitive information) and expected output? This would help us in understanding your problem and suggesting a solution.

Hope it helps!

[RajK2]

Parameter = {
("Goodwill", NAMEOF('Sales_Data'[Desc]), 0),
("Revenue", NAMEOF('_Sales_Data'[Amount2]), 1),
("Debt", NAMEOF('_Sales_Data'[Amount3]), 3),
("Rent", NAMEOF('_Sales_Data'[Amount4]), 2)}

This is parameter I used in the table and the same I filtered selection

Quarter, Country, Parameter
(bold highlighed above standard columns and parameter only dynamic)

if I filter 'Goodwill' then Goodwill will in the table OR 'Rent' select then 'Rent' will show in the table along with Quarter, Country.

My question if unselect ALL filters (parameter) then
Result

Quarter, Country, Goodwill,Revenue,Debt,Rent

Should be Result
Quarter, Country

how to avoid this. / disable unselected fields in the parameter like any code..