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

Frequent Visitor

## Convert calculated column to measure

Is it possible to convert the following calculated column to measure?

``````field widget =
var minimum =
LOOKUPVALUE('Virtual Table'[value], 'Virtual Table'[product_id],'Virtual Table'[product_id], 'Virtual Table'[type], "min")

var maximum =
LOOKUPVALUE('Virtual Table'[value], 'Virtual Table'[product_id],'Virtual Table'[product_id], 'Virtual Table'[type], "max")

var diff =
(maximum - minimum)
var mean =
DIVIDE((LOOKUPVALUE('Virtual Table'[value],'Virtual Table'[product_id],'Virtual Table'[product_id],'Virtual Table'[type],"mean")-minimum),diff)
var wavg =
DIVIDE((LOOKUPVALUE('Virtual Table'[value], 'Virtual Table'[product_id],'Virtual Table'[product_id], 'Virtual Table'[type], "wavg")-minimum),diff)
var pp =
DIVIDE((LOOKUPVALUE('Virtual Table'[value], 'Virtual Table'[product_id],'Virtual Table'[product_id], 'Virtual Table'[type], "pp")-minimum),diff)

RETURN
ABS(IF('Virtual Table'[type] = "mean",mean,
IF('Virtual Table'[type] = "wavg",wavg,
IF('Virtual Table'[type] = "min",0,
IF('Virtual Table'[type] = "max",1,
IF('Virtual Table'[type] = "product_price",pp, BLANK()))))))``````
1 ACCEPTED SOLUTION
Super User

I think you can reuse this with just a few changes. In each of your LOOKUPVALUE calls, wrap the third parameter in SELECTEDVALUE(), and do the same thing in each of the IF statements - replace 'Virtual Table'[type] with SELECTEDVALUE('Virtual Table'[type])

1 REPLY 1
Super User

I think you can reuse this with just a few changes. In each of your LOOKUPVALUE calls, wrap the third parameter in SELECTEDVALUE(), and do the same thing in each of the IF statements - replace 'Virtual Table'[type] with SELECTEDVALUE('Virtual Table'[type])

## Helpful resources

Announcements

#### Power BI Monthly Update - July 2024

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

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors