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

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.

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

    my mistake, yes, we need aggregation

     

    if("Delivery Option" IN VALUES(TableDimension[DimensionName]), MAX(Table[Delivery Option]), BLANK())

    You can work on this proposed solution but I don';t think it is very scalable and good approach, although at the same time I don't see any other solution.

     

    I will leave it upto you to make a decision to see if you want to continue on this path :)

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      :smileysad:

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

        I know, give it a try , may be it worked out.