Calculated Members or Measures that subtract values from each other

[Bjorn]

I have 2 dimensions:

Users:
use
user-1
user-
user-2
u
user-3

Reference-Users:
user-1
user-2
user-3

My Users dimension contains the measure I want to work with (visits count). The names however are not always complete, but all have Visit counts. I am trying to filter out the invalid users from Users using the reference list of users I have in Reference-Users. Both dimensions have a measurement called ‘Dummy’ which always equals 1 (otherwise I could not ingest Reference-Users.

How to do this?

[martins.vanags]

@Bjorn
You could try using the formula “Getmemberbykey” when creating a new calculated measure to find one dimension members in another dimension.
Then you would see a match for users that exist in both dimensions, other users will show empty and you can filter the report by this measure.

Try this code:

[Reference-Users].[Reference-Users].GetMemberByKey(
  [User].CurrentMember.key  
).name

When creating a calculated measure pay attention to dimension and level names.
For any custom field, the dimension name usually is the same as level name.
For predefined dimensions (like Assignee and Logged by in my examples) dimension name can differ from level name

Martins / eazyBI