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
parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago

please add it as measure

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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Trying for same... since morning