Forum Discussion
Aazam
Helper I
3 years agoDAX Total is not working
Hi, I am facing an issue with DAX Total, Here is my DAX item cost for max date = var MaxDate = CALCULATE(MAX('Lookup Table'[transaction_date]),ALL('Lookup Table'[transaction_date])) RETURN CA...
- 3 years ago
Hi Aazam
Please tryitem cost for max date = SUMX ( SUMMARIZE ( 'Lookup Table', 'Lookup Table'[Item Code], 'Lookup Table'[Item Category], 'Lookup Table'[SKu], 'Lookup Table'[Location Name] ), VAR MaxDate = CALCULATE ( MAX ( 'Lookup Table'[transaction_date] ), ALL ( 'Lookup Table'[transaction_date] ) ) RETURN CALCULATE ( SUMX ( 'Lookup Table', 'Lookup Table'[Item Cost] ), KEEPFILTERS ( 'Lookup Table'[transaction_date] = MaxDate ) ) ) - 3 years ago
I resolved it by myself
SUMX ( SUMMARIZE ( 'Lookup Table', 'INV Sku'[sku], 'INV Categories'[name], 'INV Items'[item_code], 'INV Locations'[location_name] ), VAR item_cost_for_max_date = CALCULATE ( [item cost for max date] ) VAR item_on_hand = CALCULATE( [Item_On_Hand_SUM] ) RETURN item_cost_for_max_date * item_on_hand )
tamerj1
Community Champion
3 years agoHi Aazam
Please try
item cost for max date =
SUMX (
SUMMARIZE (
'Lookup Table',
'Lookup Table'[Item Code],
'Lookup Table'[Item Category],
'Lookup Table'[SKu],
'Lookup Table'[Location Name]
),
VAR MaxDate =
CALCULATE (
MAX ( 'Lookup Table'[transaction_date] ),
ALL ( 'Lookup Table'[transaction_date] )
)
RETURN
CALCULATE (
SUMX ( 'Lookup Table', 'Lookup Table'[Item Cost] ),
KEEPFILTERS ( 'Lookup Table'[transaction_date] = MaxDate )
)
)