Distinct Count for KPI by excluding Null or Space value of Column

[harjotsingh16]

Hello 

I am facing issue in doing count to create KPI, below is the scenario 

I want to do distinct Count of "Shipment#" column where "CostLabel" column is having value, if "Costlabel" is Null then it should exclude the value. 

The data show for Null in cost label is below

Please assist me in this. 

Thanks

[vincent_ardiet_ · Accepted solution]

You can try something like:

Count (Distinct {<[CostLabel]={*}>} [Shipment#])

[harjotsingh16]

Thanks !!

This worked !

[harjotsingh16]

I have one more question, If you can help me 

I want to do sum of all shipments  with same logic 

Sum of column "Weight" having distinct "Shipment" and does not include null value from "CostLabel"

can you help me in this?

[BrunPierre]

Try

=Count(Distinct {$<Costlabel = {"*"}>} Shipment#)

[vincent_ardiet_]

When you say  'having distinct "Shipment"', do you mean at least one shipment with a costlabel?
If this is the case something like this should also work

Sum( {<[CostLabel]={*}>} [Weight])