Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
Hi @CAPSTALKER
You can try the below.
SELECTEDVALUE( YourTable[YourColumn], "return something if multiple values" )
Why you can not use any aggregations?
Hi @CAPSTALKER
Can you create a sample for both tables and based on this the outcome expected?
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?
User | Count |
---|---|
106 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |