Forum Discussion

MarkSL's avatar
MarkSL
Icon for Helper V rankHelper V
7 years ago
Solved

SELECTEDVALUE not filtering SUMMARIZEDCOLUMNS?

Hi,   Please see my example datamodel: https://www.dropbox.com/s/8s0yto6laccjzh7/Budget%20Type%20Slicer.pbix?dl=0   I have two tables which contain budgets: HardwareTargets and SoftwareTargets.  ...
General Comment
Need Help
v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi MarkSL 

You create a table with the formula.But table cannot be dynamically changed by slicer.So the selectedvalue would not work for table.It could only used in dynamic measure.For your requirement,you may use BudgetType in SoftwareTargets or HardwareTargets as slicer to filter the table.

https://www.kasperonbi.com/dax-selectedvalue-function/

https://www.sqlbi.com/articles/using-the-selectedvalue-function-in-dax/

Regards,

  • MarkSL's avatar
    MarkSL
    Icon for Helper V rankHelper V
    7 years ago

    Hi v-cherch-msft 

     

    Thanks for clarifying this for me. 

     

    You say that to filter the budget tables that I can slicer on BudgetType in SoftwareTargets or HardwareTargets, however I want one slicer to slice both tables, hence why I went with the summarised Dax table.  Would your solution not require the user to have two slicers, one for each Targets table?

     

    Thanks

     

    Mark

    • v-cherch-msft's avatar
      v-cherch-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      7 years ago

      Hi MarkSL 

      You may try below formula to create the table:

      _BudgetTypes = 
DISTINCT (
    UNION (
        SELECTCOLUMNS ( HardwareTargets, "Type", HardwareTargets[type] ,"Year",HardwareTargets[Year],"BudgetType",HardwareTargets[BudgetType]),
        SELECTCOLUMNS ( SoftwareTargets, "type", SoftwareTargets[type],"Year",SoftwareTargets[Year],"BudgetType",SoftwareTargets[BudgetType] )
    )
)

      Regards,