Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Mahamood0218
Helper II
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"

Mahamood0218_1-1670481769970.png

 

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

could you please guide me.

 

 

2 ACCEPTED SOLUTIONS
amitchandak
Super User
Super User

@Mahamood0218 a new measure

 

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

View solution in original post

Mahesh0016
Super User
Super User

Mahesh0016_0-1670486803385.png

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

View solution in original post

3 REPLIES 3
Mahamood0218
Helper II
Helper II

@amitchandak  thank you ,now formula is working

Mahesh0016
Super User
Super User

Mahesh0016_0-1670486803385.png

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

amitchandak
Super User
Super User

@Mahamood0218 a new measure

 

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.