https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-for-Filtering-in-an-existing-Measure/m-p/1820817#M38619 <LI-CODE lang="csharp">[Total Cost (no blank)] = CALCULATE( [Total Cost], KEEPFILTERS( NOT ISBLANK( VirtualMachine[VMName] ) ) )</LI-CODE> Tue, 04 May 2021 00:21:59 GMT daxer-almighty 2021-05-04T00:21:59Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-for-Filtering-in-an-existing-Measure/m-p/1820380#M38615 <P>Hello All</P><P>&nbsp;</P><P>I have the following Measure which I use in my dashboard:</P><P>&nbsp;</P><DIV><DIV><SPAN>Total Cost = SUM(VirtualMachine[MemoryCharge])+SUM(VirtualMachine[vCPUCharge])+SUM('VmDrive'[StorageCharge])+SUM('VirtualMachine'[VmCharges])</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>I need to make one adjustment. I have another field called VMName, I need the above measure to Sum where "VMName is not blank." How would I modify the above measure to include this filtered adjustment?</SPAN></DIV></DIV> Mon, 03 May 2021 17:48:08 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-for-Filtering-in-an-existing-Measure/m-p/1820380#M38615 Anonymous 2021-05-03T17:48:08Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-for-Filtering-in-an-existing-Measure/m-p/1820817#M38619 <LI-CODE lang="csharp">[Total Cost (no blank)] = CALCULATE( [Total Cost], KEEPFILTERS( NOT ISBLANK( VirtualMachine[VMName] ) ) )</LI-CODE> Tue, 04 May 2021 00:21:59 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-for-Filtering-in-an-existing-Measure/m-p/1820817#M38619 daxer-almighty 2021-05-04T00:21:59Z