Forcibly set other value in measure

[Oleg222]

Hi. Please help with the question - there is a table with indicators.

Products	Value	Branch
Product1	100	Branch1
Product1	110	Branch2
Product1	120	Branch3
Product2	200	Branch1
Product2	210	Branch2
Product2	220	Branch3
Product3	300	Branch1

Next, the power bi calculates the measure for each product separately . It is necessary that for product 3, the value in the matrix is displayed for Branch1 and Branch2, although there is no product 3 in B2. Can this be done by a measure for product3 so that it is counted separately according to the figures that are in the table and additionally shown Branch2?

Expected - the value in Branch1 must also be displayed in Branch2:

Products	Branch1	Branch2	Branch3
Product3	300	300

[Oleg222]

@PaulDBrown , thank you. But unfortunately this is not quite the case. It is necessary that the value for Product3, which is only for Branch1, is displayed additionally for Branch2, but not for Branch3.

[PaulDBrown]

Yes, sorry. I realised that after I posted. I've now edited the post to fulfil the request (see my previous post with the solution)

[PaulDBrown]

Can you post a depiction of what the expected outcome/matrix should be please?

[Oleg222]

@PaulDBrown at the end of the topic.

[PaulDBrown · Accepted solution]

With this model...

and this measure

Sum Value = SUM(FactTable[Value])

and the one for the matrix

Values for matrix =
IF (
    SELECTEDVALUE ( 'Dim Products'[Products] ) = "Product3"
        && SELECTEDVALUE ( 'Dim Branch'[Branch] ) IN { "Branch1", "Branch2" },
    CALCULATE (
        [Sum Value],
        'Dim Products'[Products] = "Product3",
        ALL ( 'Dim Branch'[Branch] )
    ),
    [Sum Value]
)

you will get this:

[Oleg222]

@PaulDBrown it works, thank you!

[PaulDBrown]

Great to hear! Just beware that if you need to include the totals, the measure must be tweaked