If Command Issues.... Bit of a newbie

[DougBee]

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

[Jihwan_Kim · Accepted solution]

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] )
)

[DougBee]

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

[ValtteriN · Accepted solution]

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/

[Jihwan_Kim · Accepted solution]

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] )
)