Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |