Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Mismatching the values from cube to Power BI reoport

Hi Team, I am facing problems like the discrepancy between the Bi report and the cube. I connected the cube by Live connection. Total amount NZD currency values are not matching? in cube and BI

Cube values:                  In BI:

Govardhaninew1_0-1652181455119.png  Govardhaninew1_1-1652181557886.png


Please me.




Frequent Visitor

Hi Evelyn Qin, thanks for your message. Amount NZD:= (Currency Amount)* (Currency Rate). I have used this formula in the cube and nothing changed in PBI as it's a live connection. Thanks

Community Support
Community Support

Hi @Govardhaninew1 ,


Could you please provide the formula for Total amount in NZD used both in Cube and PBI?



Refer to:
How to Get Your Question Answered Quickly - Microsoft Power BI Community

How to provide sample data in the Power BI Forum - Microsoft Power BI Community



Best Regards,
Eyelyn Qin

is there any idea how to bring the values same(match) both in the cube and BI

Helpful resources

September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors