Tax Gross Up Calculation with DAX

[Brookied]

Hi Guys

I need to gross up an income amount to caulcate teh amount of tax i can claim per contact.

the caulcation is

If you make a donation of €250, the approved body is deemed to have received a gross donation. The gross donation is calculated as follows:
€250/(100%-31%)=€362.32. The approved body can claim a refund of €112.32 which is €362.32x31%.

I have the sum of each contact but the above has me stummped...

Thanks in advance

[v-yalanwu-msft · Accepted solution]

Hi, @Brookied ;

You could create a measure or column as follows:

Column:

gross donation = [donation]/(1-[percent])

refund = [gross donation]*[percent]

The final output is shown below:

Measure:

gross donation2 = MAX([donation])/(1-MAX([percent]))

refund2 = [gross donation2]*MAX([percent])

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Brookied]

thats the badger - many thanks for that

[amitchandak]

@Brookied , Following as new column or measure depending on what you have

A1 = [Column/measure]/.69

A2 = [A1]*.31