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.
Hello.
As stated would appreciate suggestions.
I have 3 slicers for user input and have "selectedvalue" measures for each, two are text values (customer and location), the third is a % change value.
I am trying something of the likes of, as a measure:
If (and (selectedvalue(customer)=customer(from a column), selectedvalue(location)=location(from a column)), then volume(from a column)*(1+selectedvalue(%_Change)), else volume(from a column)
Since the measure won't let me select values from column (many), I'm at a loss
Thanks for your help
Solved! Go to Solution.
Hi @jfranco,
You can try to use the following measure formulas if it suitable for your requirement:
formula =
VAR sCustomer =
SELECTEDVALUE ( Selector1[customer] )
VAR sLocation =
SELECTEDVALUE ( Selector2[location] )
VAR sChange =
MAX ( Selector3[Change] )
VAR _percent =
IF (
AND (
sCustomer IN VALUES ( Table1[customer] ),
sLocation IN VALUES ( Table1[location] )
),
sChange
)
RETURN
SUM ( Table1[Volume] ) * ( 1 + _percent )
Comment: Selector 1, 2, 3 are three standalone tables that used as source of slicer and not have relationship to the fact table.
Regards,
Xiaoxin Sheng
Hi @jfranco,
You can try to use the following measure formulas if it suitable for your requirement:
formula =
VAR sCustomer =
SELECTEDVALUE ( Selector1[customer] )
VAR sLocation =
SELECTEDVALUE ( Selector2[location] )
VAR sChange =
MAX ( Selector3[Change] )
VAR _percent =
IF (
AND (
sCustomer IN VALUES ( Table1[customer] ),
sLocation IN VALUES ( Table1[location] )
),
sChange
)
RETURN
SUM ( Table1[Volume] ) * ( 1 + _percent )
Comment: Selector 1, 2, 3 are three standalone tables that used as source of slicer and not have relationship to the fact table.
Regards,
Xiaoxin Sheng
Hi @jfranco
Try this
IF (selectedvalue(customer)= MAX(customer(from a column)) && selectedvalue(location)= MAX(location(from a column), MAX(volume(from a column))*(1+selectedvalue(%_Change)), MAX(volume(from a column))
But without seeing your data or an examlpe of the result you expect, I'm guessing a bit.
Phil
Proud to be a Super User!
Thanks @PhilipTreacy
I can't upload my model, but I did create a simpler one with 'fake/dummy' variables (attached link) : Volumes PBIX as you can see the measure does not change any values.
BTW you and this community are awesome, this is a world I want to live in.
Thanks
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
78 | |
59 | |
51 |
User | Count |
---|---|
165 | |
83 | |
68 | |
68 | |
59 |