Forum Discussion
query does not return records
I have 2 tables which is coming from single excel sheet from two different tabs.so below query not returning any records
CombinedCriteriaCount =
var totalrows = CALCULATE(
COUNTROWS('Open'),
Open[StatusIsYesterday] = 1, -- Condition for Open (Created Yesterday)
Demand[CriteriaMOS>9] = 1 -- Condition for Demand (MOS > 9)
)
RETURN COUNTROWS(Open)
I have written the above query in my bridge table ->combinedcriteria formula
CriteriaMOS>9 = if(Demand[Months of Supply]>9,1,0)
StatusIsYesterday = if(Open[Date: Line Created].[Date] = TODAY()-1,1,0)
So im not sure why my report is not returning records but it has some datas where i checked manually for above conditions
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
2 Replies
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
