I have a Table using the Financial Reporting w/Power BI as a base to insert the rows and I would like to have a Column to give me the Diff between Actual Sales and Budgeted Sales as a percentage.
I have been able to work out the CurrentItem Variable line but the rest of the lines I cannot get the formula to work the same

This is the DAX I have written down to line 6 works fine I just cannot get the last part to work for the individual lines -

This is my table visualisation

Any help would be greatly apprecaited - I love you content by the way has helped me immensly

So changing to the following gave me an error “The Expression refers to multiple columns. Multiple columns cannot be converte to a scalar value”

% Diff Bgt vs Actual MTD Parts Analysis =
VAR CurrentItem = SELECTEDVALUE( 'PartsAnalysis2'[Items (Normalized)] )
RETURN
SWITCH( TRUE(),
CurrentItem = "Total Case IH GP", DIVIDE( [Diff BGT vs Actual MTD Parts], [Total Rev Parts BGT], 0 ),
DIVIDE( [Diff BGT vs Actual MTD Parts], [Total Rev Parts BGT], 0 ),
FILTER( 'FinancialCategories', 'FinancialCategories'[Comparison] = CurrentItem ) )

Ok I think I can see what is happening, if i remove the Formats from the numbers in the DIff measure I can then get the simple measure as you put above to work.

Do you know if there is a way to format the numbers using the Measure Modelling with a comma and negative numbers with brackets? eg: 4,000 or (4,000) I can do with a symbol but would rather not have the symbol cluttering the report