Forum Discussion

Jeffrey_VC's avatar
Jeffrey_VC
Helper III
2 years ago
Solved

Countrows exclude some value

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's avatar
    some_bih
    2 years ago

    Hi Jeffrey_VC 

    try v2 below

    Count _v2=
    CALCULATE(COUNTROWS(Logdata),
    Logdata[Datafield2] <>"9999",
    Logdata[EventType] = 0)

2 Replies