DAX for Filtering in an existing Measure

Question

Hello All&nbsp;I have the following Measure which I use in my dashboard:&nbsp;Total Cost = SUM(VirtualMachine[MemoryCharge])+SUM(VirtualMachine[vCPUCharge])+SUM('VmDrive'[StorageCharge])+SUM('VirtualMachine'[VmCharges])&nbsp;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?

daxer-almighty · Accepted Answer

[Total Cost (no blank)] =
CALCULATE(
    [Total Cost],
    KEEPFILTERS( NOT ISBLANK( VirtualMachine[VMName] ) )
)

Forum Discussion

DAX for Filtering in an existing Measure

1 Reply

Related content

Dynamic measure filtering

Filter by Rank measure

Using measure as a filter

Measure not affected by filter

DAX MEASURE TO FILTER