Production costs of products in 3 variants

[pawelj795]

Hi,
I need help with properly creating a model to evaluate production costs depending on a way to get components.
In my case, it's 3 variants.

• "Produce" - We produce components by ourselves from bought materials
• "Buy" - We buy finished components from vendors
• "Customer-Provided" - We provide bought materials to third parties, which process them into components for a specific fee. (Simply it's a "produce" variant + fee)

The default variant is "produce", so if some products (BOM) don't have a "buy" or "customer-provided" variant, it should be calculating the first one.

In my report, I want to dynamically change these valuations in variants by a slicer.
(I suppose I need to create an additional filter table with no relationships? )

Also, these evaluations could be different for each day, because material prices are changing daily.

In the end, I need to somehow combine these 3 measures into one and have all of these calculations in one BOM table.

Sample file:

https://drive.google.com/file/d/1JRV1vmfxwaJF0u80TliFXHlDTfiXwRmP/view?usp=sharing

[PaulDBrown · Accepted solution]

@pawelj795 

Assmuning your measures are correct, you need a SWITCH measure to return the measure based on the selection in the slicer:

Total Unit Cost =
SWITCH (
    SELECTEDVALUE ( Variants[Variants] ),
    "Buy", ["Buy" Total Unit Cost],
    "Customer-provided", ["Customer-Provided" Total Unit Cost],
    ["Produce" Total Unit Cost]
)

And 

to make the title dynamic:

Title = SELECTEDVALUE(Variants[Variants]) & " Variant"

I've atteched the PBIX file for your reference

[pawelj795]

.