Power BI Showing Different Results for Same Figures

[PaulHolt]

Hi,

I'm struggling to get to grips with a couple of tables outputting different figures,

I have 2 tables with the same data in them but formatted differently (RFQ Final CP is formatted as text and has 2 different currencies in them and RFQCost is formatted as a decimal number), I have both value columns on separate cards, but they are outputting different numbers on the cards, why would they output differently?

Thanks,

Paul

[v-eqin-msft]

Hi @PaulHolt ,

Maybe the Value column from RFQ Final CP has been formatted like this:

format with two currencies =
IF (
    MAX ( 'RFQ Final CP'[ID] ) <= 3,
    FORMAT ( SUM ( 'RFQ Final CP'[Value] ), "£#.00" ),
    FORMAT ( SUM ( 'RFQ Final CP'[Value] ), "€#.00" )
)

Did I answer your question ? Please mark my reply as solution. Thank you very much.

If not, please upload some insensitive data samples and expected output.

Best Regards,

Eyelyn Qin

[DavidWaters100]

@PaulHolt without seeing a sample file, did you try clicking on the funnel icon and check that any filters applying to each card visual are the same?