Insert values in a matrix by using a measure

[knut12212]

Hey guys,

does someone know what's wrong with my measure?

I would like to create a measure that looks at the date per line and then enters a number in the respective month. For the date of PM040, 40 should then be entered. Bid should be entered for Bid. CS should be entered for CS Bid. For OI then OI.

However, currently only the 40 is only entered.

[v-dineshya]

Hi @knut12212 ,

Thank you for reaching out to the Microsoft Community Forum.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.

Thank you

[v-dineshya]

Hi @knut12212 ,

Thank you for reaching out to the Microsoft Community Forum.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.

Thank you

[v-nmadadi-msft · Accepted solution]

Hi @knut12212,

Thank you for reaching out to the Microsoft Community Forum.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.

Thank you

[sjoerdvn]

That "Start of the Month" column, how is that defined? Is it a Calendar table column? Is the same value for all days in a month? Also, you what do you want to display if approval/bid submission/cs bi submission happen in the same month.
The measure code as text, and some test data would also be nice.
Like I mentioned earlier, any solution will include CALCULATE and USERELATIONSHIP. But since the two tables here are joined on Date, there is no need for the bulky expressions used here.

[leo124]

Only the first relationship is active. However, the other ones cannot be switched to an active relationship as this error occurs.

[leo124]

Yes, there is

[leo124]

What kind of additional information do you need? I will provide it then

[sjoerdvn]

With the information you are providing it is hard to say what is going on here, but my guess is there is an active relationship between 'CRM - Fokusdaten'[Bid Aaproval (PM040)]
and the 'Calendar' table, and no relationships or inactive relationships between 'Calendar' and 'CRM - Fokusdaten'[Bid Submission Date], 'CRM - Fokusdaten'[CS Bid Submission Date].
If that is the case, using CALCULATE and USERELATIONSHIP could help here.