Hello,

Does anyone know how to correctly reference a dimension in DAX?  See attached screenshot.  I'm trying to reference Email attribute within the Person dimension. 

Error Message

"Column [Email] is part of composite key, but not all columns of the composite key are included in the expression or its dependent expression."

Happy New Year to you!

the error occurs because, as it says, [Email] is part of a compound key and you need to filter on all columns of the compound key

what is important to mention here is the fact that also a name-column in multidimensional is reffered to as a compound key in DAXMD

when you run the following query:

you will realize that you get (at least) two columns for your original [Email]-attribute

one of them is suffixed as [Email.Key0] - this refers to what you defined as key-column of your multidimensional attribute. the other column is [Email] without any suffix. 
When you use CALCULATETABLE it expects the columns and values in that column to be unique which is not necessarily the case if you only filter by [Email] as two persons may have the same email-address (theoretically)
so you need to filter on [Email.Key0] if you want to use CALCULATETABLE

an other option is to use FILTER instead of CALCULATETABLE which will work in both scenarios as FILTER does not rely on unique values in a column, though FILTER might be slower

hth,
gerhard

Thanks Gerhard. 

Do I add another line right below 'Person'[Email]="TStubble" as such: 'Person'[Email.Key0]="TStubble"?

BTW, did you miss pasting the query?

Also, as you can see from my query, I already have a FILTER condition on NOT IsBlank([Actual Person]), so it does not allow me to add another condition.  Is it true that only one condition is allowed under FILTER function?  If so, why is there only one condition allowed?

Your help is appreciated!

ya, seems like i forgot to paste the query :)

here it is:
EVALUATE('Person')

just to check what columns exist in your table and which ones you need to filter

you can combine several conditions in your FILTER -function
you can either use AND() or OR() function or use "&&" for AND or "||" for OR

hth,
gerhard

Hello Gerhard,

I don't think your expression helped find the key needed for my query.
I see bunch of columns when I enter your expression.  Not sure which columns I need to add (hopefully not all of them) below my existing email column under Person dimension: 'Person'[Email]="tstubble"

See result below when I entered EVALUATE('Person'):

can you list all available columns?

the ones we are looking for would be like with "Persion[Email*"

Is nearly impossible to list all columns.  There's at least 50 if not more related to Person dimension.

I found another column related to [Email].  See image below, so I added the following line right after 'Person'[Email]="TYHILL", but still received the same error.

'Person'[Email.UniqueName]="TYHILL"

There's this Key0 field but is related to Personnel Number.  Do I also need Personnel Number?  But I wouldn't know how to filter since I wouldn't know each person's personnel number.

ok, lets try it the other way round then

how is your Email-attribut set up in the multidimensional cube?
key-column(s)? name-column? value-column?

I have no idea about the data model for I am simply a consumer of the cube.  Is there commands such as EVALUATE('Person') to decipher more about the model, especially dimension key? 

All I am trying to do is pull Person's Email attribute through DAX.  I didn't know is quite complex.

its not directly a limitation but according to microsoft its "by design":
https://connect.microsoft.com/SQLServer/feedback/details/775561/inconsistent-behavior-for-dax-queries-if-a-namecolumn-is-specified

This behavior is the current design. Due to the current 
DAX semantics and for the ability for clients to query the
key column, we expose the metadata via CSDL-BI. Clients 
are expected to interpret the CSDL-BI metadata and form
the appropriate DAX query for the right results. 

for your initial problem - could you just drag-and-drop one of the members of your EMail-attribute to the MDX window and post its unique name here? this should also reveal some more insights
please also post the name of that member

Your bug filing helps to understand some potential hassle.  However, I'm not sure how to find unique key for a given dimension.  I'm guessing the unique name might be personnel number.

I'm not sure what you mean by post unique name.  Here's screenshot of drag and drop Email attribute into MDX.  Still trying to figure out the syntax for finding unique key and DAX syntax to simply pull Email.

well, thats the designer view, you will not see any MDX 

to switch to MDX view you need to use the button in your ribbon at the very right that looks like a triangle: