DAX query with COUNTAX that doesnt seem to work

[sagivh]

Hi, I am scratching my head for some time as my query just doesnt work and i dont understand why. 

I have this table of companies, that each has many settings (so they appear multiple times) and each setting has a true/false state. 

i want to count just the number of companies that has this 'Viewer' setting enabled. thats it. 

This query seems right to me, but doesnt count things properly, and when I change the expression at the end (Enabled="True") to anything else it always just keeps the same value, like it doesnt matter...

TotalEnabled = COUNTAX(FILTER('DBView - EnabledInfo',[settingsName]="Viewer"),[Enabled]="True")

what am I doing wrong? 

[avanderschilden]

Hi sagivh,

Please try the following measure:

Spoiler

Companies with Viewer Enabled =
CALCULATE (
    COUNTROWS ( 'DBView - EnabledInfo' ),
    'DBView - EnabledInfo'[SettingsName] = "Viewer",
    'DBView - EnabledInfo'[Enabled] = TRUE ()
)
​

[Anonymous]

please share sample data and expected output.