Forum Discussion
Formatting issues
Hi, when creating a measure, some instances I am unable to have the option to select the format of my measure, in particular, I want to have zero decimal places as shown below. Is it because the numerator and denominator both have differring formats so it confuses Power BI when they are used in a new meausre via DIVIDE DAX?
kind regards
arnie
Hi arniet ,
You are trying to return an integer and a string value in the same Measure.
Try Like this measure
Net Sales per order = Divide ( [MTD Curr [Net Sales] , [MTD Curr] , BLANK())
Regards,Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
9 Replies
Hi arniet ,
You are trying to return an integer and a string value in the same Measure.
Try Like this measure
Net Sales per order = Divide ( [MTD Curr [Net Sales] , [MTD Curr] , BLANK())
Regards,Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!That could be an issue with the latest version of PBI, I have also faced a couple issues in June release that were not in the previous versions. Try switching applications and it might get unfreezed.
Anonymous Thank you for pointing out a grammatical error on a PBI forum.
Thank you everyone for your input and resolving my query, much appreciated!!
Hi arniet ,
Thanks.
Please mark the correct solution as Solved.
Will help others in the community.
Thanks
HN
