Forum Discussion

Marek_Wojciech's avatar
Marek_Wojciech
Frequent Visitor
2 years ago

Problem with correctly filtering a fact table based on another table

Hi, I'm taking my first steps in DAX and I have a simple model consisting of two tables. I created two measures (Generation and Generation1), the first returns the sum of generations, the second also...
Need Help
parry2k's avatar
parry2k
Super User
2 years ago

Marek_Wojciech try this:

 

Gen 1 Measure = 
VAR __ComDate = MIN('tblUnits'[ComDate])
VAR __DeComDate =  MIN('tblUnits'[DeComDate])
RETURN
SUMX(
    FILTER ( 
       'tblGeneration',
       'tblGeneration'[Date] <= __DecComDate &&
       'tblGeneration'[Date] >= __ComDate
    ),
    'tblGeneration'[power]
)