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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.