Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Dynamic Filters on Dimension and Measures

Hi All, I want to display the diimension and their measures based on selection in the Table Visual. Like below Delivery Type, Brand, Manufacturer .... Materials these all are dimenssions and SKUs,...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Can isue Swicth in stead of if so that I can do it in single siwtch statement like blow:

SWITCH(SelectedValue(TableDimension[DimensionName]), "Delivery Type", Table[Delivery Type],and so on

parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago

unfortuantely i don';t think switch will work on this, and I also thing selectedvalue is going to work , I just gave you an idea, selectedvalue only works if user select one value in the slicer.

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    8 years ago

    Instead of selectedvalue you need to check following and that will take care if use selected more than one value in slicer:

     

    if("Delivery Option" IN VALUES(TableDimension[DimensionName]), Table[Delivery Option], BLANK())
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Created a below column 

    SelectedDim = IF(SELECTEDVALUE('Dimensions'[Dimensions])="Delivery Type",KPI_Sales[Delivery Type],"NUll") 

     

    when I select Delivbery Type in slicer below it still does not refletc Delivery Type with its values form main table.

     

    It seems Selected Value is not working for single value too.

     

    Thanks

     

     

    • parry2k's avatar
      parry2k
      Icon for Super User rankSuper User
      8 years ago

      please add it as measure

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Adding it as measure will ask me to specify aggrgation....but I want that whole coulmn to display after selection and not aggrgated value.