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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
setis
Post Partisan
Post Partisan

IF and SELECTEDVALUE with multiple conditions

Dear experts,

I have the following issue. 
I have a slicer with several elements. When 2 specific elements are selected, I want a specific calculation and if they are not, I want another one. 

 

I'm trying:

 

IF(
        SELECTEDVALUE(G_L Entry'[BU]) = "B2B"||
        SELECTEDVALUE(G_L Entry'[BU]) = "B2I";
        [Revenue] * [ExchRateCurrency];
        "" )

 

Another way that it's not working either: 

IF(
OR(  
        SELECTEDVALUE(G_L Entry'[BU]) = "B2B";
        SELECTEDVALUE(G_L Entry'[BU]) = "B2I");
        [Revenue] * [ExchRateCurrency];
        "" )

 

Could somebody help, please?

 

1 ACCEPTED SOLUTION
tex628
Community Champion
Community Champion

Sorry i was abit to quick there! 🙂 

IF(
AND(
        FIRSTNONBLANK(G_L Entry'[BU];G_L Entry'[BU]) = "B2B" ||
        FIRSTNONBLANK(G_L Entry'[BU];G_L Entry'[BU]) = "B2I" ;
        LASTNONBLANK(G_L Entry'[BU];G_L Entry'[BU]) = "B2B" ||
        LASTNONBLANK(G_L Entry'[BU];G_L Entry'[BU]) = "B2I" ) ;
        [Revenue] * [ExchRateCurrency];
        "" )

Connect on LinkedIn

View solution in original post

5 REPLIES 5
tex628
Community Champion
Community Champion

 While there is more than 1 value in G_L Entry [BU] selectedvalue() will always return blank(). That is why your measure is not working. You need to use FIRSTNONBLANK() and LASTNONBLANK() to find the two values. 

IF(
AND(
        FIRSTNONBLANK(G_L Entry'[BU]) = "B2B" ||
        FIRSTNONBLANK(G_L Entry'[BU]) = "B2I" ;
        LASTNONBLANK(G_L Entry'[BU]) = "B2B" ||
        LASTNONBLANK(G_L Entry'[BU]) = "B2I" ) ;
        [Revenue] * [ExchRateCurrency];
        "" )


Br,
J


Connect on LinkedIn

@MartynRamsden I am getting blanks when those are selected.


@tex628 Sounds logical. Thanks. 
I think that I'm missing someting. I am getting the error "Too few arguments were passes to the FIRSTNONBLANK function. The minimum argument count for the function is 2."

tex628
Community Champion
Community Champion

Sorry i was abit to quick there! 🙂 

IF(
AND(
        FIRSTNONBLANK(G_L Entry'[BU];G_L Entry'[BU]) = "B2B" ||
        FIRSTNONBLANK(G_L Entry'[BU];G_L Entry'[BU]) = "B2I" ;
        LASTNONBLANK(G_L Entry'[BU];G_L Entry'[BU]) = "B2B" ||
        LASTNONBLANK(G_L Entry'[BU];G_L Entry'[BU]) = "B2I" ) ;
        [Revenue] * [ExchRateCurrency];
        "" )

Connect on LinkedIn

@tex628 Perfect. It works. Thank you so much!

@MartynRamsden Thanks a lot for your help too. 

MartynRamsden
Solution Sage
Solution Sage

Hi @setis 

 

Both expressions look ok to me.  What result are you seeing?

 

Have you tried IN?

Measure = 
IF(
    SELECTEDVALUE( G_L Entry'[BU] ) IN { "B2B", "B2I" };
    [Revenue] * [ExchRateCurrency];
    ""
)

 

Best regards,
Martyn


If I answered your question, please help others by accepting it as a solution.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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