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
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] ))Regards
Miguel Félix
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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] ))Regards
Miguel Félix
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHelpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
We want your feedback!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
A Year in Review - December 2024
Find out what content was popular in the Fabric community during 2024.
