Forum Discussion
Creating a measure using multiple tables
Hi There, I am new to this forum and require some assistance in creating a measure that displays the sum of a column which has been filtered by certain criteria. However I have tried numerous wa...
Hi cass_butchard ,
Try the following measure
It is assumed that there is a relationship between Defects and Date table.
Oustnding DefectsEOM = CALCULATE(
SUM(Defects[Estimatedquantity]),
FILTER( Defects,
Defects[CompletionDate(ShortDate)] > 'Date'[MonthEnd] || Defects[CompletionDate(ShortDate)] = BLANK()
))
Let me know if it worked.
Cheers
CheenuSing
Hi There,
I have tried the above solution however even though there is a relationship between the date table and defect table I am unable to use a field from the date table in the filter statement without the generate statement connecting the two tables together. Screen shots below: