Forum Discussion
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]),FIL...
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 :)
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 :)