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 = 

SUMX(
    FILTER ( 
       'tblGen',

       'tblGen'[Date] < RELATED ( tblUnits[DeComDate] ) &&
       'tblGen'[Date] > RELATED ( tblUnits[ComDate] )
    ),
    'tblGen'[power]
)

 

 

 

  • Marek_Wojciech's avatar
    Marek_Wojciech
    Frequent Visitor
    2 years ago

    At the same time, after careful analysis, I came to the same solution. Thank you for your time and suggestion, which allowed me to find a solution.