Filter option in Master item

[harsha]

Hello people,

I'm stuck in middle and please read my problem below.

I have added a measure in Master items which gives me results based on the condition like "Match" or "No match".

My requirements:

1. I want to have a filter on master Item (Check Compare). I can currently sort on CheckCompare column but not filter however I can filter Source_ID,Source_Period columns

2. I want to have count of the results in separate chart from Master item.. like count of "Match" and Count of "No Match"   

I have attached QVF file here for ur reference...thanks in advance 🙂

 

[lorenzoconforti]

Regarding being able to filter, you defined a master measure (CheckCompare) not a dimension; just define a master dimension:

=If((Aggr(If(Match(Source_Combo, Dest_Combo), 1, 0), Source_Combo, Dest_Combo)) > 0, 'Match', 'No Match')

To be able to count, just use the master dimension I mentioned above and count on whichever elements you want (e.g. Source_ID)

[harsha]

Thank u for your time and reply. I created a master dimension as well, however, I couldn’t get it into the table and the error is “ invalid dimension “.

Could you please check the attached QVF file, make changes and help me with this?

Appreciate your support

[lorenzoconforti]

Try the formula I gave you before

[harsha]

Hi,

I'm able to define master dimension however rows are duplicated... can u check ? 

[lorenzoconforti]

Remove the Check Compare measure

[harsha]

I have removed Master comparison however still the duplicates are there

[lorenzoconforti · Accepted solution]

Try this as your master dimension

=aggr(If(Sum(Aggr(If(Match(Source_Combo, Dest_Combo), 1, 0), Source_Combo, Dest_Combo)) > 0, 'Match', 'No Match'),Source_Combo)

[harsha]

Thank you.. it worked for me... 😀 I could create master dimension and filter option

But I'm not sure how to get count of Matches/no matches ... would really appreciate if you can guide me

[lorenzoconforti]

Can you please explain exactly what you need? I didn't understand completely from your first post