Count occurrences of domains - specific user

[chonchar]

@parry2k @Erokor 

Good morning, All,

I have a table as seen below called "Fiscal 23." In that table I have multiple columns. Two of which are "Screened By" and "Domain."

I currently have a count of ALL domains totals as a measure. 

What I need now is a measure that caclulates the Domain totals less 1 specified user in the Screened By Column. 

I will use myself as the example. Notice I have 3 occurrences of my domain in the above table. 

I would like the measure to output this:

Notice that there are only four occurrences of domains (minus the three that are tied to the user name "chonchar."

Thank you,

Cam

[Anonymous · Accepted solution]

Hi @chonchar ,

Please try to create a measure with below dax formula:

Measure =
VAR cur_domain =
    SELECTEDVALUE ( 'Table'[Domain] )
VAR tmp =
    FILTER ( ALL ( 'Table' ), 'Table'[Screened By] <> "CHONCHAR" )
VAR tmp1 =
    CALCULATETABLE (
        VALUES ( 'Table'[Screened By] ),
        FILTER ( tmp, [Domain] = cur_domain )
    )
VAR _result =
    COUNTROWS ( tmp1 )
RETURN
    _result

Add a table visual with field and measure:

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[chonchar]

@Anonymous 

Great Solution. Thank you very much. 

That measure (which works) only counts the distinct occurrences of the domains. 

How would I count the occurrences of each of those domains in my data model and not just the distinct users?