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

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 

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

    I hear ya, so are we getting somewhere or still need further help.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    we need help, am trying to serach online for same...

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

    what happened to proposed solution, did you tried it?

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    I cant use aggrgated function as I need whole olumn value to display

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi Anonymous,

    Please create a table inclusing dimension value, create another measure using switch function. More details, please review this blog.

    Best Regards,
    Angelia

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi Anonymous,

    Have you resolved your issue? If you have, welcome to share your solution or mark the right reply as answer. More people will get useful information from here.

     

    Thanks,
    Angelia

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

    gnanavadivel100link doesn't open, although I already did it recently but would like to see what are the other methods.