Dealing with ship date filters when some lines have not shipped

DAX DAX Calculations
6

Hi @Usates,

For that you need to look into fixing totals

.

A pattern like this will do the job.

Total Qty Ordered Card = 
VAR vTable = FILTER( Sales, [ShipDateFilter] =1 )
RETURN

CALCULATE( SUM(Sales[Qty Ordered]),
    vTable
)
1 Like