Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi Team,
I'm trying to set up a card to show the number (this is set up as a string in the model) of the account related to the below measure.
When I have in the category slicer "DNP Cost" is selected and there is another one for the period (in this case the month of Sep).
The measure is a card and will show 8.9m in this case which is correct and relates to the highest value on this category.
I would like to have another card that shows "480001" which is the account driving this value.
Is this possible?
Thanks in advance.
Hi @Anonymous ,
Have you tried the LOOKUPVALUE formula?
Once you know the highest number is 8.9m, you can use LOOKUPVALUE to find the account associated to that number.
Does this help you?
LC
Interested in Power BI and DAX templates? Check out my blog at www.finance-bi.com
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |