Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
CAPSTALKER
Helper I
Helper I

Getting non-calculated values from Excel

Hi all, 

 

My goal is simple. I'm trying to get TargetIT values from excel where I have Department and TargetIT.

There is a relationship between Excel-Department and Table1-Department. 

 

Now, when I'm filtering with the corresponding TargetIT should be shown.

 

How can I get non-calculated values? Meaning there will not be used SUM, MAX, MIN, COUNT, etc.

1 ACCEPTED SOLUTION

Hi @CAPSTALKER 

You can try the below.

 SELECTEDVALUE( YourTable[YourColumn], "return something if multiple values" )
 

Why you can not use any aggregations?

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski

 

View solution in original post

3 REPLIES 3
Mariusz
Community Champion
Community Champion

Hi @CAPSTALKER 

 

Can you create a sample for both tables and based on this the outcome expected?

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski

 

Department | TargetIT
AKK | 9,2
EKK | 9,1
FAM | 5,3
OPP | 5
PRO | 4,8
VTN | 4,2
XLR | 5,5

 

Table1 is huge, but there is a column containing above Department values.

 

For example when page is filtered by Table1-Department and set to XLR the value on visual should be 5,5.

Not any of the summarized values, SUM,MAX,MIN,COUNT...

Hi @CAPSTALKER 

You can try the below.

 SELECTEDVALUE( YourTable[YourColumn], "return something if multiple values" )
 

Why you can not use any aggregations?

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski

 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!