KPI tile returning a value based on multiple variables

[asad98]

Hi guys, I am fairly new to power bi and am trying to learn. I have a case and want to see if power bi is able to do this. So the case goes like this,

I have multiple products, let's say A, B, C, D that can be sourced from multiple sources S1, S2, S3 and each source has its own cost for specific assets. Sample dataset would like below : -

| Asset | Source |    Cost     |

|    A    |     S2    |    1000     |

|    B    |     S3    |     2000    |

|    C    |     S1    |     3000    |

|    A    |     S3    |     500      |

|    B    |     S1    |     4000    |

|    A    |     S1    |     1500    |

|    B    |     S2    |      2500   |

|    C    |     S2    |      3000   |

Now would it be possible to create a measure that returns a value indicating where I should order asset A from - S1, S2, or S3 so I can get the same product from the cheapest source. Maybe it can be possible to select a number of sources and the measure will calculate based on the selected sources.

Any help will be very appreciated!

Thank you!

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[amitchandak]

@asad98 ,  USe this for source and Min for cost

Min Source =
VAR __id = MAX ('Table'[Asset] )
VAR __Cost = CALCULATE ( MIN('Table'[Cost] ), ALLSELECTED ('Table' ), 'Table'[Asset] = __id )
RETURN CALCULATE ( MIN ('Table'[Source] ), VALUES ('Table'[Asset ),'Table'[Asset] = __id,'Table'[Cost] = __Cost )