Forum Discussion
Solved
Distinct Net Value From Deliveries
I am pulling a report from my ERP that lists deliveries shipped at the item level but populates the total net value shipped for delivery on each item line (repeating the total net value for the de...
Net Val = SUMX(FILTER(SUMMARIZE('Delivery Tracking',[Delivery],[Act. Gds Mvmnt Date],[Net Value]),FORMAT([Act. Gds Mvmnt Date],"yyyymm")=FORMAT(TODAY(),"yyyymm")),[Net Value])FORMAT([Act. Gds Mvmnt Date],"yyyymm")=FORMAT(TODAY(),"yyyymm")We are comparing the YearMonth of your data against the YearMonth of the "current" month, ie today's month.
Ok one more question. I thought I could figure it out but just can't. Just as I asked for the net value I need a total count of deliveries shipped for current month. Data is below and it should show four deliveries shipped in March (current month).
| Delivery | Act. Gds Mvmnt Date |
| 88029082 | 2/29/2024 |
| 88029067 | 2/29/2024 |
| 88029065 | 2/29/2024 |
| 88029051 | 2/29/2024 |
| 88029008 | 2/29/2024 |
| 88028983 | 2/29/2024 |
| 88028982 | 2/29/2024 |
| 88028980 | 2/29/2024 |
| 88028975 | 2/29/2024 |
| 88028955 | 2/29/2024 |
| 88027883 | 2/29/2024 |
| 88030339 | 2/29/2024 |
| 88024733 | 3/1/2024 |
| 88030531 | 3/4/2024 |
| 88030531 | 3/4/2024 |
| 88030531 | 3/4/2024 |
| 88031827 | 3/4/2024 |
| 88031827 | 3/4/2024 |
| 88031827 | 3/4/2024 |
| 88031827 | 3/4/2024 |
| 88031827 | 3/4/2024 |
| 88031827 | 3/4/2024 |
| 88031742 | 3/4/2024 |
| 88031742 | 3/4/2024 |
| 88031742 | 3/4/2024 |
| 88031742 | 3/4/2024 |
| 88031742 | 3/4/2024 |
You can use the implicit "Count (Distinct)" in the visual for that, or implement the same in the formula explicitly.
Right I am using this below to get the distinct count of deliveries but can't seem to restrict it to the current month.
Count of Deliveries Shipped = DISTINCTCOUNT('Delivery Tracking'[Delivery])