cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

KPI tile returning a value based on multiple variables

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III
Super User III

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

2 REPLIES 2
Super User IV
Super User IV

@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 )



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Super User III
Super User III

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors