Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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?
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
113 | |
105 | |
95 | |
58 |
User | Count |
---|---|
175 | |
147 | |
134 | |
105 | |
82 |