wrong output for matrix

[Anonymous]

Hello,

I appreciate it, if you could tell me what is my mistake.  

Inputs:

output:

my data model is :

i implemented it with matrix but it shows me wrong data for run time. instead of showing 2050 for month 9, it shows 2050 for all months.

Could you please help me to find out my mistake?

Thank you in advance.

Mahsa

t

[MFelix · Accepted solution]

Hi @Anonymous 

The issue is wiht the inactive relationship between you date table and you capacity ledger, if you make this relationship active and use the month from that table on your calculation you get the correct resutls:

If you have any other issue that does not allow to have this relationship active create the following measure:

RUNTIME =CALCULATE (SUM(capaciy[Run Time]), USERELATIONSHIP(capaciy[posting date],Date[Date] ))