Forum Discussion
query does not return records
In reading the original measure I think it's just correcting the RETURN statement. Change it to this instead
CombinedCriteriaCount =
var totalrows = CALCULATE(
COUNTROWS('Open'),
Open[StatusIsYesterday] = 1, -- Condition for Open (Created Yesterday)
Demand[CriteriaMOS>9] = 1 -- Condition for Demand (MOS > 9)
)
RETURN TotalRows
In reading the original measure I think it's just correcting the RETURN statement. Change it to this instead
CombinedCriteriaCount =
var totalrows = CALCULATE(
COUNTROWS('Open'),
Open[StatusIsYesterday] = 1, -- Condition for Open (Created Yesterday)
Demand[CriteriaMOS>9] = 1 -- Condition for Demand (MOS > 9)
)
RETURN TotalRows
CombinedCriteriaCount =
var totalrows = CALCULATE(
COUNTROWS(Open),
Open[StatusIsYesterday] = 1, -- Condition for Open (Created Yesterday)
Demand[CriteriaMOS>9] = 1 -- Condition for Demand (MOS > 9)
)
RETURN if(totalrows>0,"Created Yesterday: " & totalrows &" having more than 9 months ", "Nothing was created yesterday meeting criteria of more than 9 months"
)
Highlighted in red showing blank total but visual reports displaying some data below