https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Datetable-as-Filter/m-p/1543485#M30445 <P>Sorry to say that but your measure does not make any sense. The syntax of SUMX is completely different. Secondly, if you want to know how to CORRECTLY build models is Power BI, then you must read this:&nbsp;<A href="https://docs.microsoft.com/en-us/power-bi/guidance/star-schema" target="_blank">Understand star schema and the importance for Power BI - Power BI | Microsoft Docs</A></P> Thu, 10 Dec 2020 16:24:02 GMT daxer-almighty 2020-12-10T16:24:02Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Datetable-as-Filter/m-p/1543436#M30439 <P>Hi,</P><P>&nbsp;</P><P>I have a fact table with date and revenue. Now I want to see ony the revenue of the actual month. I created a measure, something like</P><P>SUMX(revenue, FILTER(facttable, facttable[date}&gt;blabla)</P><P>&nbsp;</P><P>Now someone told me it would be better to have a date table and use this for filtering.</P><P>&nbsp;</P><P>Now my question: Do I need to create a calculated "filtered" data table and create a relationship or is there another way with a measure?</P><P>&nbsp;</P><P>Thx Chris&nbsp;</P> Thu, 10 Dec 2020 15:47:27 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Datetable-as-Filter/m-p/1543436#M30439 _chris_ 2020-12-10T15:47:27Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Datetable-as-Filter/m-p/1543485#M30445 <P>Sorry to say that but your measure does not make any sense. The syntax of SUMX is completely different. Secondly, if you want to know how to CORRECTLY build models is Power BI, then you must read this:&nbsp;<A href="https://docs.microsoft.com/en-us/power-bi/guidance/star-schema" target="_blank">Understand star schema and the importance for Power BI - Power BI | Microsoft Docs</A></P> Thu, 10 Dec 2020 16:24:02 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Datetable-as-Filter/m-p/1543485#M30445 daxer-almighty 2020-12-10T16:24:02Z