Forum Discussion

Jeffrey_VC's avatar
Jeffrey_VC
Icon for Helper III rankHelper 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 nee...
  • 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)
some_bih's avatar
some_bih
Icon for Community Champion rankCommunity Champion
2 years ago

Hi Jeffrey_VC 

try v2 below

Count _v2=
CALCULATE(COUNTROWS(Logdata),
Logdata[Datafield2] <>"9999",
Logdata[EventType] = 0)
  • Jeffrey_VC's avatar
    Jeffrey_VC
    Icon for Helper III rankHelper III
    2 years ago

    Hi some_bih,

     

    Thanks, this is working!