I am attempting to create an expression to count the number of rows if a field is blank/null. I am getting an error that says the value cannot be determine: either the row does not exist or there is no current row for the column. This is the expression I am using:
Number of Single Package shipments:=CALCULATE(DISTINCTCOUNT([No_]),
[First Package No_]=””)
The field [No_] is the package id number. If the shipment contains multiple packages, the [First Package No_] field will have entries. If the shipment does not contain multiple packages, the [First Package No] will be blank. I need to know how many shipment id numbers are associated with a single package as shipments with multiple packages can have 1 or more packages and is not a reliable way to calculate the actual number of shipments sent out.
I know the error is not telling me the expression is wrong, just that it cannot be completed without a row usage. I am assuming that this is a situation where a calculated column would be better. Since I brought the data in through PowerQuery I assume that I need to add the column in PowerQuery but do not know the required ‘M’ for that. If it helps, the table is ‘BB Posted Package’.