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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
asdf1608
Helper V
Helper V

How to do unit conversion in power BI

I need to display values based on the particular unit conversion

The formula is value/Unit conversion. 

I have created the parameter for unit conversion but not sure of how to include the both in same column.

How do I get this in power BI.

I have attached the sample power BI file.

Help with this is appreciated.

Thanks in advance

 

1 ACCEPTED SOLUTION

3 REPLIES 3
johnt75
Super User
Super User

Try

Converted value = SUMX(
	'Sheet1',
	DIVIDE(
		'Sheet1'[Value],
		SELECTEDVALUE( 'Unit Conversion'[Column2], 1 )
	)
)

Can you please apply this in the power BI file so that it will be easy for me to check.

Please

Sample.pbix

 

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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