Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Total not summing properly

Hello. I have created a measure that calculates the sales for new customers for fiscal prior year last full month, Fiscal February fiscal year 2021. The ParentMinDate is the date the customer had the...
Need Help
bcdobbs's avatar
bcdobbs
Community Champion
4 years ago

A few thoughts...

1) Can you share  the DAX for [InvoicedSalesCohort].

2) If you comment out your current return and instead replace with RETURN StartDate what is shown in the total? (Then do same with RETURN EndDate.

 

Is it possible to share a sanitised PBIX file? 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Ben, yes I have tried to replace the VAR with actual dates and Iget the same total. The calc for  [InvoicedSalesCohort] is jsut the sum of a column. I get the same total when I put in the sum(Cohort[Sales]) instead of [InvoicedSalesCohort].

 

InvoicedSalesCohort:=
CALCULATE(
      sum(Cohort[Sales]),
          Cohort[is_revenue_ind]=1
)

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Im not able to send a workbook its connected to a network.

  • bcdobbs's avatar
    bcdobbs
    Community Champion
    4 years ago
    I think it has something to do with the flags for fiscal period.
     
    What appears in the total when you change measure to...
    SalesCohortPyfm =
    VARStartDate=CALCULATE(MIN('Calendar'[calendar_date]),FiscalIndicators[is_pyfm_ind]=1)
    VAREndDate=CALCULATE(MAX('Calendar'[calendar_date]),FiscalIndicators[is_pyfm_ind]=1)

     

    Return
    StartDate
    • bcdobbs's avatar
      bcdobbs
      Community Champion
      4 years ago

      Actually can you share a picture of your model. Specifically how your calendar and FiscalIndicstors is related.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Sure its joined by calendar date.