Forum Discussion

DougBee's avatar
DougBee
New Member
4 years ago
Solved

If Command Issues.... Bit of a newbie

Hi - I have a single value card in a report - if I have multiple orders when I select a customer it by default displays the first one. I'd like the value on that card to count the number of orders and if it's greater than 1 to display 'Multiple orders' and if there is only 1 order matching the filters to display the order number.

 

I have 

 

Measure=IF(COUNT(Order[OrderNumber])>1, "Multiple Orders", Order[OrderNumber] )
 
It doesnt work and I can see the only options seem to be measures not dimensions - is there a way to force it to select the measure value?
 
Thanks
DAX
dimensions
if
Measures
syntax
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    I am not sure how your datamodel looks like, but please try the below whether it suits your requirement.

     

    Measure =
IF (
    COUNT ( Order[OrderNumber] ) > 1,
    "Multiple Orders",
    MAX ( Order[OrderNumber] )
)
  • ValtteriN's avatar
    ValtteriN
    4 years ago

    Hi, 

    Here is an example on how to do this:

    Data:


    Dax:

    Order num or multiple = IF(COUNT('Table (9)'[Order])>1,"Multiple",MAX('Table (9)'[Order]))

    You were close just add MAX, MIN or SELECTEDMEASURE


    End result:

     

    I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

    My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

3 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    4 years ago

    Hi,

    I am not sure how your datamodel looks like, but please try the below whether it suits your requirement.

     

    Measure =
IF (
    COUNT ( Order[OrderNumber] ) > 1,
    "Multiple Orders",
    MAX ( Order[OrderNumber] )
)
  • ValtteriN's avatar
    ValtteriN
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi, 

    Here is an example on how to do this:

    Data:


    Dax:

    Order num or multiple = IF(COUNT('Table (9)'[Order])>1,"Multiple",MAX('Table (9)'[Order]))

    You were close just add MAX, MIN or SELECTEDMEASURE


    End result:

     

    I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

    My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

  • DougBee's avatar
    DougBee
    New Member
    4 years ago

    Thanks to Both of you for helping out - much appreciated 😄