https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Measure/m-p/3143716#M112364 <P>Please see this article...<A href="https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523" target="_blank">How to Get Your Question Answered Quickly - Microsoft Power BI Community</A></P> Tue, 21 Mar 2023 02:24:56 GMT BrianConnelly 2023-03-21T02:24:56Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Measure/m-p/3143712#M112363 <P>Hi Everyone,</P><P>I am quite new to Power BI. I have cases table where I am looking for cases in last 14 days and 28 days respectively. I’ve created 2 measures, I am using ‘Case Date’ from the table to filter those cases which looks correct. But when I try to display this into a Power BI report table where I’ve added a column ‘Area’ total are showing the exact as the measure are showing, but in the table numbers are not quite adding up. I believe the measure are now calculating from the max case date associated from a particular area column. I don’t want to filter from today’s date I want this work when user select date range from slicer and it work dynamically. Thank you very much for your help.</P> Tue, 21 Mar 2023 02:22:30 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Measure/m-p/3143712#M112363 chattha 2023-03-21T02:22:30Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Measure/m-p/3143716#M112364 <P>Please see this article...<A href="https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523" target="_blank">How to Get Your Question Answered Quickly - Microsoft Power BI Community</A></P> Tue, 21 Mar 2023 02:24:56 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Measure/m-p/3143716#M112364 BrianConnelly 2023-03-21T02:24:56Z