topic Same Measure - Different Results for Card and Multi-Row Card in DAX Commands and Tips

Same Measure - Different Results for Card and Multi-Row Card

jselman — Sat, 19 Feb 2022 16:02:54 GMT

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.

Re: Same Measure - Different Results for Card and Multi-Row Card

tackytechtom — Sat, 19 Feb 2022 16:19:27 GMT

Hi 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.tackytech.blog/

https://www.instagram.com/tackytechtom/

Re: Same Measure - Different Results for Card and Multi-Row Card

jselman — Sat, 19 Feb 2022 17:55:56 GMT

Hi Tom.

Thank you for responding. A screen shot is below:

John

Re: Same Measure - Different Results for Card and Multi-Row Card

tackytechtom — Sat, 19 Feb 2022 18:22:35 GMT

Hi John,

This is strange and I have to admit that I do not know why it behaves likes this. Maybe it has something to do with the format of the other measures that you are using?

Here there were discussing something similar:

Solved: Remove Scientific notation in measure - Microsoft Power BI Community

/Tom

https://www.tackytech.blog/

https://www.instagram.com/tackytechtom/

Re: Same Measure - Different Results for Card and Multi-Row Card

Anonymous — Tue, 22 Feb 2022 07:42:54 GMT

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.

Re: Same Measure - Different Results for Card and Multi-Row Card

jselman — Fri, 25 Feb 2022 12:56:40 GMT

Hello.

This workaround worked perfectly. Thank you.