Countrows exclude some value

[Jeffrey_VC]

Hi,

I'm looking for a solution to count rows but I need to exclude some data.

Now i have the following measure:

Count =

CALCULATE(COUNTROWS(Logdata),

Logdata[EventType] = 0)

But I need to exclude to column logdata.Datafield2 with the value "9999".

Any sugestions?

Greets, Jeffrey

[some_bih · Accepted solution]

Hi @Jeffrey_VC 

try v2 below

Count _v2=

CALCULATE(COUNTROWS(Logdata),
Logdata[Datafield2] <>"9999",

Logdata[EventType] = 0)

[Jeffrey_VC]

Hi @some_bih,

Thanks, this is working!