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' in the filter then result: 

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

 

please guide dax code on this

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

6 Replies

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

  • danextian's avatar
    danextian
    Super User
    6 months ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 months ago

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

  • v-prasare's avatar
    v-prasare
    Community Support
    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

  • v-prasare's avatar
    v-prasare
    Community Support
    6 months ago

    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