Grouping the results of a measure by category ( Date, Shipping Lane, Supplier#, Sales Center#)

[Anonymous]

I would like to see if someone can help me. I want to be able to get a shipment count grouped by the following categories,

Carrier Pickup date, supplier#, sales center #, and shipping lane... I've been able to calculate and group the shipments with no issues however i can't seem to figure out how to apply filters to the results... i have some shipments which have not been picked up so the date is blank and i want to filter only grouped results that are greater than 1 indicatiting that there is an opportunity for shipment consolidation.

Here was my first attempt... i get results howeve i want to be able to filter by shipments > 1 and ignore those blank values in the carrier picked up column.

CALCULATE(

DISTINCTCOUNT(SupplyChainReportTMC[TMC Load]),

GROUPBY(

SupplyChainReportTMC,

SupplyChainReportTMC[Carrier PU Date],

Vendor_Listing[Vend#],

SupplyChainReportTMC[Lane],

SupplyChainReportTMC[Branch #]))

[v-easonf-msft]

Hi, @Anonymous 

Could you please tell me whether your problem has been solved?
If it is,  please mark the helpful replies or add your reply as Answered to close this thread.
More people will learn new things here. If you haven't, please feel free to ask.

Best Regards,
Community Support Team _ Eason

[Anonymous · Accepted solution]

I've actually come up with a different solution for the problem.. i've aggregated the data in Power Query and filtered out occurances greater than 1.

For the "Same Week" extracted the week of the year and GroupBy that column to get that count.

[NamishB]

Hi @Anonymous - Have you tried something like :

CALCULATE(

DISTINCTCOUNT(SupplyChainReportTMC[TMC Load]),

<Filter_Column with value>,

GROUPBY(

SupplyChainReportTMC,

SupplyChainReportTMC[Carrier PU Date],

Vendor_Listing[Vend#],

SupplyChainReportTMC[Lane],

SupplyChainReportTMC[Branch #]))

I am not too sure if this with work with groupby clause. If you can share sample data

I just took reference from- https://stackoverflow.com/questions/35425962/power-bi-dax-distinct-count-filtered-by-condition

if this helps.

Cheers,

-Namish B