Forum Discussion
Distinct Count
Hello all, when I am filtering V code the disctinct count of B Code SA should show 10 excluding blank. Similarly S code should show 1. However, It is showing 11 for B code SA and 2 for S code. What...
Hi _Junayetrahman ,
Please use the DISTINCTCOUNTNOBLANK function if you don't want to count blanks.
https://learn.microsoft.com/en-us/dax/distinctcountnoblank-function-dax
Been using DISTINCTCOUNTNOBLANK only still showing 11