Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
jfranco
Frequent Visitor

DAX Measure : If(selectedvalue="value from column", then...

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

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

3 REPLIES 3
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
PhilipTreacy
Super User
Super User

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



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.