Forum Discussion
CarlsBerg999
Helper V
Helper VCalculate with inactive relationship
Hi,
Im having issues with my DAX formula. The issue
Revenue Forecast = CALCULATE(SUM('FactTable'[Net Value]),
ALL('FactTable'),
'FactTable2'[Indicator]=false,
FILTER('FactTable', MONTH('FactTable'[Invoice Date]) = month('Forecast'[Date])),
FILTER('FactTable', YEAR('FactTable'[Invoice Date]) = YEAR('Forecast'[Date])),
'FactTable2)'[Task Status] <> "Stopped")
The issue is with the references to the FactTable2. There is an inactive relationship between FactTable and FactTable2. Therefore the filter is not working. How do i change the dax code to activate the inactive relationship for this calculated column?
The issue is with the references to the FactTable2. There is an inactive relationship between FactTable and FactTable2. Therefore the filter is not working. How do i change the dax code to activate the inactive relationship for this calculated column?
Thanks!
You would need to use USERELATIONSHIP Dax to use the attributes from other table which is connected with inactive relationship.
Refer: https://dax.guide/userelationship/
2 Replies
PC2790Community Champion
You would need to use USERELATIONSHIP Dax to use the attributes from other table which is connected with inactive relationship.
Refer: https://dax.guide/userelationship/
CarlsBerg999
You may also use Treatas or Intersect when dealing with virtual relationship.Physical and Virtual Relationships in DAX - SQLBI
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
