Id like to count the number of 0% occurrences that appear from my Utilization Measure column in this table. in the example i provide the answer should be 2 not 152 which i believe is looking at all entries in the head count table.
Im close i feel but missing something from the virtual table.
See screen shot and PBIX
Number Of 0 % Utilizations =
‘Head Count’[Employee Number],
“Is 0”, [Total Employee Utilization %]
[Is 0] = 0
EDNA Count If 0%.pbix (1.2 MB)