COUNTAX returning correct count, but result is not interacting with Visuals

[TimothyMooney]

Hi All!

I have been battling with this measure for the last day. I have tried numerous different versions of this dax formula (ie. Countrows, Searchrows, Countax etc.) They have all given me the same result. I get the correct result from the measure, but  it appears that the result is not interacting with my visuals.

The image below shows the measure I am battling with called Resigned.

I am counting the specific row value called "Disabled User Account" from column CI User Active

Mo Device Cost is speaking to the cost of the devices. As the screenshot shows, the table on the right is showing the MO Device Cost for the total number of device (4544) filtered by year. It is not filtering correctly by the measure.

The following is the result that is meant to display

The column has two values, Active and Disabled User Account. 

I have another measure that has added all users with registered devices and my aim is to take this measure and subtract by the number of disabled users and then display the cost change.

[TimothyMooney]

Hi @Anonymous ,

Sample data is as follows:

This is the column that I am trying to do a count on in the table 'Adviser & Sales Manager'

Specifically on 'Disable User Account'

Other relevant aspects is this column refering to the type of devices and cost for those specific devices

Let me know if this is sufficient?

[Anonymous]

Hi @TimothyMooney ,

Please show some sample data so that we could test the formula.

Best Regards,

Jay