Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
PaulHolt
Frequent Visitor

Power BI Showing Different Results for Same Figures

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

PaulHolt_0-1600245191299.png

PaulHolt_0-1600246110249.png

 

 

 

2 REPLIES 2
v-eqin-msft
Community Support
Community Support

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" )
)

 

9.17.4.1.png

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
Post Patron
Post Patron

@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?

 

Proud to be a Super User!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.