Getting non-calculated values from Excel

[CAPSTALKER]

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.

[Mariusz]

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.

[CAPSTALKER]

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...

[Mariusz · 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.