Forum Discussion
jselman
4 years agoNew Member
Same Measure - Different Results for Card and Multi-Row Card
I created a measure. It reads correctly in a Multi-Row Card, but incorrectly in a Card. Please see below. Any ideas how to fix this? Thank you.
- Anonymous4 years ago
Hi jselman ,
This issue has been submitted internally(ICM ID:231504209). Please be patient to wait for fixing. If there is any news, I will update it here.
And I reproduced your problem.
As a workaround, you can use a measure to round values between -0.000001 and 0.000001 to zero, then the automatic exponential notation format should not take place anymore. For example,
Measure = ROUND(SUM('Table'[column]),2)Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
tackytechtom
Most Valuable Professional
4 years agoHi jselman ,
What data type is your measure?
It might solve your issue if you explicitly set the data type to what you'd like.
/Tom
https://www.instagram.com/tackytechtom/
jselman
4 years agoNew Member
Hi Tom.
Thank you for responding. A screen shot is below:
John