Subtracting a cell value from a another cell (measure) in a single column

[morther]

I have a Measure with a value of 131 that I call "Active Devices". I have field called Maintenance[Devices] which is a count of devices that have had maintenance.

I have a Card that Counts the number of Devices with with Maintenance. It is calculating properly at 125.

I would like to have a count of devices which Did Not have Maintenance, so I would like to take the Total Active Devices (131) and subtract Count of Devices with Maintenance (125) and have a result of (6).

I tried the following, but the result is always 125.

NoMaint = Maintenance[TotalActiveDevices] - (COUNT(Maintenance[DEVICE_ID]))

NoPMCount = ImportCubicPM[TotalActiveDevices] - CALCULATE(COUNT(ImportCubicPM[DEVICE_ID]))

any ideas?

Thanks in advance

[Ashish_Mathur]

Hi,

I suspect it has to do with some table relationship missing.  Share your file.

[morther]

I wanted to share my file but not sure how to do that here.  Are you talking about the pbix file?

[Interkoubess]

Hi @morther,

Yes ideally your pbix file.

Ninter

[morther]

I have this file all ready to attach, but i do not see any way to do that.  Any ideas?

[Greg_Deckler]

Tough without sample data, but you want a measure that is like:

All Devices = CALCULATE(COUNT([Column]),[Active]="Yes")

Subtract your maintenance measure from that.

[GilbertQ · Accepted solution]

Hi @morther

What I would suggest is to create seperate measures for each of your requirements.

And then you can calculate your final measure by using the two previous measures as shown below.

Active Devices = COUNT('ImportCubicPM'[TotalActiveDevices])

Maintenance Devices = COUNT('ImportCubicPM'[Device_ID])

Devices with No Maintenance = [Active Devices] - [Maintenance Devices]

[morther]

Below is what I actually did, which is very similar to your calculation.

No PM = Drive_Station[AD] - COUNT(Drive_Station[Device_ID])

Thank you so much.

[GilbertQ]

Awesome glad you got it working