Forum Discussion

NLRI_78's avatar
NLRI_78
Frequent Visitor
4 years ago
Solved

Multiple values error in calculate DAX

Hi there,    This is my query on here, no doubt the first of many! 🙂   This should be a straightforward query to answer but any help will be greatly appreciated.   I've used the following DAX ...
Tutorial Requests
  • NLRI_78's avatar
    NLRI_78
    4 years ago

    Thanks so much, that worked perfectly. No idea why it thought there was more than one row but clearly there must have been. 

     

    Thanks again, really appreciate your help 🙂

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

Based only on your DAX my guess would be that 'Date Updated' currently has more than one row:

 

YTD Actuals =
CALCULATE (
    SUM ( 'New FPR'[Actuals] ),
    'New FPR'[Fund Center Group] <> "Admin-Prog Hierarchy",
    'New FPR'[Dates.Period] <= VALUES ( 'Date Updated'[Period] )
)

 

See if this works:

 

YTD Actuals =
CALCULATE (
    SUM ( 'New FPR'[Actuals] ),
    'New FPR'[Fund Center Group] <> "Admin-Prog Hierarchy",
    'New FPR'[Dates.Period] <= MAX ( 'Date Updated'[Period] )
)
NLRI_78's avatar
NLRI_78
Frequent Visitor
4 years ago

Thanks so much, that worked perfectly. No idea why it thought there was more than one row but clearly there must have been. 

 

Thanks again, really appreciate your help 🙂