[amarinesParticipant Started: 1Replies: 4Total: 5]

OHHHH yess  you did that in the first answerr!! LOL

 

Solved with no changes at all:

Yes you rigth!!, No limitation in DAX, after a very hard learning hours

Average_value: = CALCULATE (AVERAGE (table3, table3[value]), table2 )

What do you thing??

Ragrads!!

 

 

 

[amarinesParticipant Started: 1Replies: 4Total: 5]

Hi OK!

thanks you for the link

Regrads

[amarinesParticipant Started: 1Replies: 4Total: 5]

Hello,
haha, well, yes I like puzzles, but this, I did not mean it was one.

Thank you for your correct answer,

I choose to correct the data model, thanks to your answer now can see a little more clearly how this works, well I think 🙂

I assumed that PowerPivot could easily identify one-one relationship, but it is not, I think.
Therefore, I believe, I can not carry out any operation of aggregation (sum, average, count) in a calculated field when the measure is in a lookup table in a relationship one to one while grouping by a field in another lookup table in a many-to-one.

This is because PowerPivot will see it as a many-to-many relationship?

It will be a limiting factor in PowerPivot?

regards

[amarinesParticipant Started: 1Replies: 4Total: 5]

Hello Thanks for your answer

but no, its not many to many relationship

Here is the example attached

What i need is the average from he field “Value” on tabla3

Thankyou very much

 

 

 

 

Attachments:

You must be logged in to view attached files.

[Author]

Posts