Forum Discussion

EnrichedUser's avatar
EnrichedUser
Icon for Helper III rankHelper III
3 years ago

Incorrect Totals: - Matrix

Hi,  I have an issue with a measure(s) that I have exhuasted all other resources to solve.    I am trying to solve for "Monthly Inflation" which is defined as: ( [Last Unit Cost] - [Base Unit C...
Need Help
EnrichedUser's avatar
EnrichedUser
Icon for Helper III rankHelper III
3 years ago

Thanks for the attempt, but was not sucessful. 

 

Here is my latest go:

Monthly Inflation (TEST) = 
VAR VirtualTable = 
ADDCOLUMNS(
    SUMMARIZE(
        GENERATE(
            VALUES(Receipts[Site_Item_Key]),
            VALUES('Date'[Year Month])
        ),
        Receipts[Site_Item_Key],
        'Date'[Year Month]
    ),
    "@Monthly Inflation", [Monthly Inflation (R)]
)
RETURN
IF(
    ISINSCOPE( Receipts[Site_Item_Key] ) && ISINSCOPE( 'Date'[Year Month] ), 
    [Monthly Inflation (R)],
    SUMX( VirtualTable, [@Monthly Inflation] )
)