Totals of the Decimal numbers not showing correctly in power bi

[baijumohan1990]

Hi ,

Noticed power bi is not computing the totals correctly if the values are decimal. in the below example Rating total would be 0.0008 + 0.0007 = 0.0015, but total showing is 0.0011. 

Any help much appreciated.  Same issue occurs at the total KPI's in Card visuals as well. 

[baijumohan1990]

@amitchandak  Thanks for the reply.   Rating is merely a division of  unique views and total base.  below forumla used : 

DIVIDE([unique views],[CLOSING BASE],0)

i edited the question to include the total base also for your better understanding.   When I changed the measure formula to Sumx(data,DIVIDE([unique views],[CLOSING BASE],0))  against each line i am getting a different value. for eg :  65/81027 is 0.0008 but with sumx the result is 0.0011

[amitchandak · Accepted solution]

@baijumohan1990 , This Sum of Avg, you need have group by

Sumx(Values(Data[PromoTitle]),calculate(DIVIDE([unique views],[CLOSING BASE],0))  )

[baijumohan1990]

Thanks. the measure need to be computed on the cumulative level so 0.0011 is expected result. But have an issue when i computed another measure mulitplying rating and frequency  ( 0.0011 * 170 )  the result is 0.0195 , but the expected result is 0.0187 . could you give your thoughts on this?

[baijumohan1990]

Thank you  :).  will try this out. the old formula's didnt work because of the DIVIDE function?

[Anonymous]

HI @baijumohan1990,

According to your description, it seems like a common measure total issue.
For this scenario, you can refer to the following blog to know how to handle multiple aggregate calculations in measure expression:

Measure Totals, The Final Word 

Regards,

Xiaoxin Sheng

[amitchandak]

@baijumohan1990 , You need share formula, Grand total are recalculated .

You can force sum using, assuming Rating measure

Sumx(Values(Table[PromoTitle]), [Rating] )