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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
viralpatel21
Helper II
Helper II

Measure Grand total not matching

Hello team,

 

i have created a measure where the grand total should be £96656.89 but im getting a different grand total.

 

This is my measure :

GBPConverstion =
var convertgbp = CALCULATE(
SUM('FX Rates'[GBP_Avg]) * [Card Spend GBP],
USERELATIONSHIP(Presentment[Settlement Date],FeeDate[Date]),
USERELATIONSHIP(FeeDate[Months],'FX Rates'[Months])
)
var previousmonthfx = CALCULATE(
SUMX('FX Rates','FX Rates'[GBP_Avg]),
PREVIOUSMONTH(FeeDate[Date])
)
var previousmth = CALCULATE(
[Card Spend GBP] * previousmonthfx,
USERELATIONSHIP(Presentment[Settlement Date],FeeDate[Date]),
USERELATIONSHIP(FeeDate[Months],'FX Rates'[Months])
)
return
IF(convertgbp=BLANK(),previousmth,convertgbp)

 

Screenshot 2020-11-30 at 17.19.10.png

 

please could you help

1 ACCEPTED SOLUTION
mahoneypat
Microsoft Employee
Microsoft Employee

Please try this to get the correct total.  It references your existing measure.  Use it in place of your current measure in the visual.  

 

New GBPConversion = SUMX(VALUES('Date'[Month]), [GBPConversion])

 

Regards,

Pat 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

3 REPLIES 3
mahoneypat
Microsoft Employee
Microsoft Employee

Please try this to get the correct total.  It references your existing measure.  Use it in place of your current measure in the visual.  

 

New GBPConversion = SUMX(VALUES('Date'[Month]), [GBPConversion])

 

Regards,

Pat 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Thank you for this. That did work.

However i really didnt want to call it to another measure. Is there a way, where i could have it all in one measure?

Hi @viralpatel21 ,

 

It may need to transform the measure into a table (virtual table) and use the table as a parameter in your measure expression.  Then sumx("the virtual table", [the transformed column]). If you can show me some data and I'll test for you.

 

 

Best regards

Icey

 

If this post helps, then consider Accepting it as the solution to help other members find it faster.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors