Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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
@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?
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |