Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

TotalMTD not returning a value

Hello, 

I would like to show MTD Net Sales and copied a similar DAX formula that works for another page. I've adjusted to pull TotalMTD. There are no errors showing, however, the field is blank in the visual. Any help would be appreciated. 

 

TOTALMTD(SUM(Full_Data[opportunity.Net_New_Sales__c]),Full_Data[opportunity.CloseDate].[Date],FILTER(Full_Data,Full_Data[opportunity.IsClosed] = TRUE && Full_Data[opportunity.StageName]= "Closed Won"))
Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    7 years ago

    First of all, remove the filter clause and check if it working or not. Then put them one by one and check which filter is causing it.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    7 years ago

    Hi,

    This isn't how it should be.  Create a Calendar Table and build a relationship from the Close Date column to the Date column of the Calendar Table.  In the Calendar Table, extrac the Month Name by using this calculated column formula: Month = FORMAR(Calendar[Date],"mmmm").  Build a slicer from the Month column of the Calendar Table and select any Month.  Try this measure

    =CALCULATE(SUM(Full_Data[opportunity.Net_New_Sales__c]),Full_Data[opportunity.IsClosed] = TRUE,Full_Data[opportunity.StageName]= "Closed Won")

    Hope this helps.