MTD calcuation not working

[Anonymous]

My MTD revenue calculation does not seem to be working.   It seems to be aggregating months, not just giving me the current month which is what I want.  

Even if I put a slicer in it, the slicer is ignored.     I'm just trying to get current Month revenue  (and yes, the other things in that calculation are needed in order to filter out customers we do not want to count).   

MTD Revenue = CALCULATE (

    'Flu Shipped'[Total Shipped Value]-[MTS Gebroeders Deferral],FILTER('Master Customer List','Master Customer List'[Customer ID]<>"C-04646"),FILTER('Master Customer List','Master Customer List'[Customer ID]<>"C-05165"),FILTER('Master Customer List','Master Customer List'[Customer ID]<>"C-04821"),

    CALCULATETABLE(

    DATESMTD ( 'DateTable'[Date] ),

    DateTable[DatesWithShipments] = TRUE

)

)

[Anonymous]

Hi @texmexdragon

Whether your problem has been resolved? If no, could you please provide the required info? Like some sample data(exclude sensitive data), table structure and relations between tables refer in measure etc. Thank you.

Best Regards

Rena

[Anonymous]

Hi @Anonymous

Which date(Month) do you use for the filtering ? Is the date from table DateTable ? Is there any relationship between table “Flu Shipped” , table “Master Customer List” and table DateTable ? In addition , does the table DateTable and table " Flu Shipped " establish a relationship by date field ? Could you please provide the structure of the three tables mentioned in your measure formula and some sample data exclude sensitive data?

Best Regards

Rena

[Greg_Deckler]

Sample/example data to recreate the problem is always appreciated. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

I don't see any ALL or ALLSELECTED functions in your code so that is not the problem. I guess make sure that there is a relationship between your date table and your fact table. 

See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...