Forum Discussion
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.
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.
3 Replies
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.Department | TargetIT
AKK | 9,2
EKK | 9,1
FAM | 5,3
OPP | 5
PRO | 4,8
VTN | 4,2
XLR | 5,5Table1 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.
