Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can try something like:
Count (Distinct {<[CostLabel]={*}>} [Shipment#])
You can try something like:
Count (Distinct {<[CostLabel]={*}>} [Shipment#])
Thanks !!
This worked !
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?
Try
=Count(Distinct {$<Costlabel = {"*"}>} Shipment#)
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])