cancel
Showing results for
Did you mean:
Helper II

## how to divided two fields in measure dax function.

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.

2 ACCEPTED SOLUTIONS
Super User

@Mahamood0218 a new measure

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

!! Microsoft Fabric !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Solution Sage

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

3 REPLIES 3
Helper II

@amitchandak  thank you ,now formula is working

Solution Sage

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

Super User

@Mahamood0218 a new measure

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

!! Microsoft Fabric !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!