Removing Decimals in a measure

[microsoftrookie]

Hello,

In my report I have visualizations that are in measures since I am not able summarize or total any of my data because they would be inaccurate. My measures all follow the same format; measure=IF(ISFILTERED(table1[Column1]),SUM(table2[Column3]), "Not Applicable" )

I cannot change this measure from ""not applicable" to 0 and set a Round function inside the visualization as well; since doing so would mean if someone were to click see data or download the data without filtering(which unfortunately happens too often), 0 would appear and that would not only be inaccurate but also incredibly misleading for not only supervisors but also the general public.  With the previous measure as the value, my tooltip when I hover over the data shows the decimal with two spaces(hundreths) Numeric Sample Change Current as in the "Numeric Sample Change"(a measure like the one shown before) Value as shown. In my query editor the Numeric Change (the actual numbers not the measure) is formatted to be a whole number.(That number is just 3651 in the query editor) 

   My understanding of what is happening is that since I am displaying a measure in the visualization rather than  column, the visualization defaults all numbers (since it is not sure what data type a measure is) to the hundreths column, and does not give an option the sidebars to change a measure's formatting. I just want to know if it is possible to get these numbers down to a whole number. Thank you for your time;

Regards,

Microsoft Rookie.

[Greg_Deckler · Accepted solution]

You should be able to change your measure format to Whole Number or set your decimal places to 0. This would be on the Model tab.

[microsoftrookie]

Thank you for your quick reply,

However, in the query it is already set to being a whole number so that is not the problem; and the modeling and changing the type does not work because I cannot change a measure from being a whole number in the modeling tab because it recognizes the measure as having text type data because the measure is an if statement with a text type ,,false format. 

I did not think it would be possible to lose these decimal points, because it technically is neither text nor number but rather it floats between the two.

Thank you again however for your speedy reply,

Regards,

Microsoft Rookie