Use measures as name as dimension in filters

[Sunil645454]

I have around 12 measure and 10 dimension in my table and above that table I have filters. these 12 measures are divided like 7 and 5 so there will be 4 filters.

Filter1 -  suppose I have give 7 measure in my table and named as measure1 to measure 7 so I will have filter that would have these measure list from 1 to 7

Filter2 - have bucket of values that I have in my table like >5 Lakhs, 5-10 Lakh and till 25 Lakhs

Filter3 - have rest of the 5 measure and have name as Measure8 to measure12 names list

Filter4 - have again bucket from >5 Lakhs , 5-25 Lakhs and so on till >2 Crores

Now based on the selections my tables measure should reflect , like user select Filter 1 -measure 5 and Filter 2  5-10 Lakh then in my table all values should come between 5-10 Lakh only and same for 3rd and 4th filter whatever measure selected table measure should reflect according to that. FYI- All measure are different not same in filter 3 there will be another measure that should also reflect accordingly

[Sunil645454]

Thanks for giving time on this, the qvf you shared the old one not the updated one. I think you need to share the new pdf where you implemented the logic

[rubenmarin]

Hello @Sunil645454, uploaded again.

[Sunil645454]

its not meeting my requirment that I asked a week ago with qvf, and there i am not using unit price and sales amount

[rubenmarin]

To hide the rows you only need to uncheck the option to include zero values. This is an example on how to use the selectors to filter values

[Sunil645454]

yes that will hide the rows, but there is other things as well that i mention and as per your qvf the data is not coming correctly, that is why I said I have mentioned the requirement, please look into it

[rubenmarin]

I don't understand the requirement, you want the filters pairs to work as an 'or' instead of an 'and'?

In that case it's only change the last part of the variable to 

If(($(=Parameter1Expression)>=$(=Bucket1Min) and $(=Parameter1Expression)<$(=Bucket1Max)) or ($(=Parameter2Expression)>=$(=Bucket2Min) and $(=Parameter2Expression)<$(=Bucket2Max))

About the unit prices: you can change that, as I said it's an example and you can adapt to your real needs