Decimal to whole number

[whygeent]

hi, i have a problem in making the TOTAL a whole number while retaining the upper values as decimal number. Supposedly the result of the 5 values is 24, 173.5 but i need to make it 24,172 and as a whole number. Is there any possible way can i make the total a whole number while retaining the values above the total?

[Ritaf1983 · Accepted solution]

Hi @whygeent 

You can use isfiltered/hasonefilter + format functions to manipulate the totals.
something like :

pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Ritaf1983 · Accepted solution]

Hi @whygeent 

You can use isfiltered/hasonefilter + format functions to manipulate the totals.
something like :

pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[whygeent]

as i can see, your age group came from a different table. but mine is only from one table. how can is use this function using one table? im using the MTD column name to format.

[Ritaf1983 · Accepted solution]

Hi @whygeent 

It will work with 1 table too

new pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[budhie]

hi, can you elaborate more on how you can get the total amount of 24,172? thanks

[whygeent]

it was from the another cell with a total of 24,172.