Assign Value of a group to another group with same parent hierarchy

[pbixnewbie]

Hi,

I would like to get the following output from in my PowerBI Visualization. The below representation is a matrix in my PowerBI Report. The Value column is a measure. The Measure column is the output I'd like to get. 

Essentially, what I'm looking to do is for every customer number, assign the value of Sale Type B to all rows for that Customer Number. Any help would be very much appreciated! 

[Samarth_18]

Hi @pbixnewbie ,

You could use the following code:-

Measure = 
CALCULATE(
    MAX('Table'[Value]),
    FILTER(
        ALL('Table'),
        'Table'[Customer Number] = SELECTEDVALUE('Table'[Customer Number])
            && 'Table'[Sales Type] = "B"
    )
)

[pbixnewbie]

Thanks Samarth! I tried this, but the 'Value' field in my table is a Measure itself. Hence, the MAX function doesn't accept it as a parameter. Any suggestions? 

[Samarth_18 · Accepted solution]

Please try this:-

Measure = 
CALCULATE(
    [Value],
    FILTER(
        ALL('Table (3)'),
        'Table'[Customer Number] = SELECTEDVALUE('Table'[Customer Number])
            && 'Table'[Sales Type] = "B"
    )
)