Exclude "N/A" OR Blanks

[Anonymous]

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 · Accepted solution]

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 🙂