TotalMTD not returning a value

[Anonymous]

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"))

[v-chuncz-msft]

@Anonymous 

You may take a look at the links below.

• https://www.sqlbi.com/articles/time-intelligence-in-power-bi-desktop/
• https://www.sqlbi.com/articles/filter-arguments-in-calculate/

[Ashish_Mathur]

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.

[amitchandak]

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.