Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Exclude "N/A" OR Blanks

I am trying to count a field exluding blanks and N/A in another field I did write the below but wont work .
 
 
COUNT OF NTP = CALCULATE(DISTINCTCOUNT(TXGLOMonitoringMasterTracker[NTPNumber]),FILTER(OR(TXGLOMonitoringMasterTracker,TXGLOMonitoringMasterTracker[ClientApprovedSS] <> BLANK(), IN { "N/A"})
 
Appreciate any ideas suggestions.
 
TIA
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi,

     

    You can use the below DAX Syntax.

    Measure:= COUNTROWS(CALCULATETABLE(Table, Table[Field]<> BLANK() && Table[Field]<>"#N/A"))

    Best Regards,
    Vignesh M

    If what I suggested worked for you feel free to Drop a "Kudos" and Consider to "Accept as Solution" if I solved your Issue :)

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi,

     

    You can use the below DAX Syntax.

    Measure:= COUNTROWS(CALCULATETABLE(Table, Table[Field]<> BLANK() && Table[Field]<>"#N/A"))

    Best Regards,
    Vignesh M

    If what I suggested worked for you feel free to Drop a "Kudos" and Consider to "Accept as Solution" if I solved your Issue :)