I have a column in the data spreadsheet that = £288kThe transformed data in the PBI = £288k The measure calculation in the card I have created = £300k I do not understand how to fix this. I have used the exact same calculation/measure in other reports and not had this problem.

Just ignore this. I think I've figured out why. CALCULATE ( SUM ( 'consolidated'[value] ), 'Consolidated'[Financial] = "Commitment" ) This part of the formula 'Consolidated'[Financial] = "Commitment" is internally translated to FILTER(ALL(Consolidated[Financial]), Consolidated[Financial] = "Commitment") which filters all rows where Financial is "Commitment" and applies this filter across the entire Consolidated[Financial] column. Therefore, unless the filter originates from a different column, the result remains consistent regardless of the value selected in Consolidated[Financial]. Change it to CALCULATE ( SUM ( 'consolidated'[value] ), KEEPFILTERS ( 'Consolidated'[Financial] = "Commitment" ) )

Calculation is not producing the correct figure

Forum Discussion

Related content

Calculating correct Average

Correcting Data

Producing Correct Totals and Subtotals with a SUMX

Dax Formula correction help

Dax correction