Forum Discussion

CAPSTALKER's avatar
CAPSTALKER
Helper I
7 years ago
Solved

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, w...
Need Help
Show and Tell
  • Mariusz's avatar
    Mariusz
    7 years ago

    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

     

Mariusz's avatar
Mariusz
Community Champion
7 years ago

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

 

CAPSTALKER's avatar
CAPSTALKER
Helper I
7 years ago

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's avatar
    Mariusz
    Community Champion
    7 years ago

    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