Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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?