Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 months ago
Solved

Table selection

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...
Need Help
  • v-prasare's avatar
    v-prasare
    6 months ago

    Hi Anonymous,

    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

alish_b's avatar
alish_b
Super User
6 months ago

Hi Anonymous ,

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!

Anonymous's avatar
Anonymous
Not applicable
6 months ago

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..