Forum Discussion

clo_64's avatar
clo_64
Frequent Visitor
4 years ago

Sum multiple results from COUNTROWS

Hi, I would like to count all the New Customers for the actual year (= YTD).   My measure works very well when I use it and build a table with the date 'Date'[Date]   But how can I sum all the...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi clo_64 ,

 

Try:

measure =
SUMX (
    FILTER ( ALLSELECTED ( 'date' ), 'date'[date] >= DATE ( 2022, 1, 1 ) ),
    [New Customers YTD]
)

If I misunderstood your meaning, please share some sample data.

 

Best Regards,

Jay

  • clo_64's avatar
    clo_64
    Frequent Visitor
    4 years ago

    Hi Jay,
    The result that I get is not correct! The measure gives me 44K, and I expect around 400.
    I'll try to debug in DAXstudio and share my findings later
    Thanks