Forum Discussion

cphite's avatar
cphite
Icon for Helper I rankHelper I
4 years ago
Solved

inconsistent Measure results by date

So I have a table BILLING_DATA which is a list of invoices, which is joined to a table FISCAL_CALENDAR by the invoice date.   The FISCAL_CALENDAR table has a column (added in power bi) called isCY ...
  • tamerj1's avatar
    tamerj1
    4 years ago

    cphite 

    Please try

    Billings CY =
    CALCULATE (
    'Billings Details'[Billings],
    FILTER ( 'Fiscal Calendar', 'Fiscal Calendar'[isCY] = "Y" ),
    ALLEXCEPT ( 'Billings Details', 'Billings Details'[InvNo] )
    )

     

    I suspect that you might have have two directional relationship?

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

cphite 

Please try

Billings CY =
CALCULATE (
'Billings Details'[Billings],
FILTER ( 'Fiscal Calendar', 'Fiscal Calendar'[isCY] = "Y" ),
ALLEXCEPT ( 'Billings Details', 'Billings Details'[InvNo] )
)

 

I suspect that you might have have two directional relationship?

cphite's avatar
cphite
Icon for Helper I rankHelper I
4 years ago

Close!  I had another table for orders that was also joined to FISCAL_CALENDAR and it was set to filter both ways.  I changed that to single and now the measure is working 😄

 

Thanks!  I wouldn't have found it without your suggestion!  Still kinda new at this Power BI thing...