Hi experts, i have data in Data base as shown in below, i want to create a measure as below

[Ganesh31]

i have a data in sql as show in above figure, now i want to make a measure in power bi by taking only few coloumns such as  

measure = (shed1 po washing line *3) + (shed2 - Dynamic-PCU * 4) 

how to do that please suggest the way to that!

[v-yiruan-msft · Accepted solution]

Hi @Ganesh31 ,

You can create a measure as below to get it, please find the details in the attachment.

Measure =
VAR _shed1 =
    CALCULATE (
        SUM ( 'Table'[Consumption] ),
        'Table'[Meter] = "Shed1-PO Washing Line"
    )
VAR _shed2 =
    CALCULATE ( SUM ( 'Table'[Consumption] ), 'Table'[Meter] = "Shed2-Dynamic-PCU" )
RETURN
    _shed1 * 3 + _shed2 * 4

Best Regards

[VijayP]

Lets us asume your table name is Table

then the formula will be

Calculate ( sum(Table[consumption]), Filter(all(Table[Meter]), Table[Meter]=" shed 1 " || table[meter] = "shed 2]))*3

[VijayP]

@Ganesh31 

You must be more clear !

Do you want the value of consumption of Shed1 multiplied by 3 and if you can give a business objective , will help me to answer you!

[Ganesh31]

yes,i want to create a measure by taking only few rows out of whole data

measure = (shed 1's Consumption *3)+(shed 2's consumption*4)