Forum Discussion
inactive relationship is not working properly.
Hi,
Active relationships are the primary links used by Power BI to relate tables in a data model.
Only one active relationship can exist between two tables at a time.
Inactive relationships are secondary links that can be used for specific calculations. Keep it in mind these relationships only use in dax It will not work on all page or other visuals.
As per I undersand the problem statement. you need same month created and resolved bugs count. if it is right then you need to change your dax. you can try below dax may it will work for you
CALCULATE (
DISTINCTCOUNT( 'Created Bug all'[Target ID] ),
USERELATIONSHIP ( 'Created Bug all'[Modified Resolved Date], 'MOdified date table'[Date] ),
('Created Bug all'[Test code defect bugs.State]="Resolved" || 'Created Bug all'[Test code defect bugs.State]="Closed"),
Month('Created Bug all'[Modified Resolved Date]) = Month('MOdified date table'[Date]),
Year('Created Bug all'[Modified Resolved Date]) = Year('MOdified date table'[Date])
)
- Regards
Vikas