TOTALS INCORRECT WHEN USING MAXX

cdawidow — Fri, 15 Oct 2021 12:23:30 GMT

Hi there,

I just need help calculating dynamic totals within Power BI for the following measure shown below . Essentially, I am calculating the last recorded Average Cost and QTY On Hand across my 3 branches for a specific product ( TXWHSE) to get my Inventory Value. But by using MAXX I know why my totals are based on the MAXX value but my desired output is to SUM the total inventory Values across all 3 of my branches as my total amount. In this case, it should show $52,455.15 . How would I go about doing that ?

Re: TOTALS INCORRECT WHEN USING MAXX

Jos_Woolley — Sat, 16 Oct 2021 07:11:57 GMT

Hi,

INVENTORY VALUE = VAR LASTQ0H = CALCULATE ( MAXX ( INTRAN00, INTRAN00[TXQOH] ), LASTDATE ( INTRAN00[TRANSACTION DATE] ) ) VAR LASTAVGCOST = CALCULATE ( MAXX ( INTRAN00, INTRAN00[NEW AC PER] ), LASTDATE ( INTRAN00[TRANSACTION DATE] ) ) VAR MYTABLE = SUMMARIZE ( INTRAN00, INTRAN00[TXWHSE], "LastQ0H", CALCULATE ( MAXX ( INTRAN00, INTRAN00[TXQOH] ), LASTDATE ( INTRAN00[TRANSACTION DATE] ) ), "LastAvgCost", CALCULATE ( MAXX ( INTRAN00, INTRAN00[NEW AC PER] ), LASTDATE ( INTRAN00[TRANSACTION DATE] ) ) ) RETURN IF ( HASONEVALUE ( INTRAN00[TXWHSE] ), LASTAVGCOST * LASTQ0H, SUMX ( MYTABLE, [LastAvgCost] * [LastQ0H] ) )

Regards

topic TOTALS INCORRECT WHEN USING MAXX in DAX Commands and Tips

TOTALS INCORRECT WHEN USING MAXX

Re: TOTALS INCORRECT WHEN USING MAXX