query does not return records

[bzeeblitz]

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

[d_m_LNK · Accepted solution]

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

[bzeeblitz]

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