how to divided two fields in measure dax function.

[Mahamood0218]

Hi PBI experts,

i am new to PBI ,I have two fields "Tax Amount" and Local Currency, i want to find out measure dax function i.e "Divided function"

example : divide function = 7800/82.56 = 94.47 it should be new measure column.

could you please guide me.

[amitchandak · Accepted solution]

@Mahamood0218 a new measure

sumx(Table, divide([Tax Amount], [local Currency])

[Mahamood0218]

@amitchandak  thank you ,now formula is working

[Mahesh0016 · Accepted solution]

Hello @Mahamood0218 ,
I hope It is Helpful for you.

[amitchandak · Accepted solution]

@Mahamood0218 a new measure

sumx(Table, divide([Tax Amount], [local Currency])