cancel
Showing results for
Did you mean:
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])

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])

Announcements

#### Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

#### Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors
Top Kudoed Authors