Measure to show specific position of values

[Victormar]

Hi all,

I have a measure where I return the name of a fleet whenever a customer or a fleet is selected in a slicer (otherwise blank is returned), like:

IF (

    (

        HASONEFILTER ( DIM_Chassis[FLEET_FLEET_ID] )

            || HASONEFILTER ( DIM_Chassis[CONTRACT_CUSTOMER_NAME] )

    )

    ,MAX ( DIM_Chassis[FLEET_FLEET_ID] ),

    ""

)

I wonder if I could return the following value after MAX, in case a Customer with 2 fleets is selected, or the user selects two fleets.

Thanks for your support! 😄

[Ashish_Mathur]

Hi,

Use the CONCATENATEX() function.  If it does not help, then share some data and show the expected result.

[Victormar]

Hi!

It's a possibility, although I would like to get different measures for every fleet, so I could visualize them on top of each other, like:

Makes sense?

Thanks for your reply 🙂

[v-shex-msft]

Hi @Victormar,

In fact, max function not only work from get the maximum value from table, but it will also dynamic change based on current row context.

You need to add a category/group field to help this formula calculate based on current row context. (for card visual, the row context which measure processed should be match with table level)

Row Context and Filter Context in DAX - SQLBI

Regards,

Xiaoxin Sheng

[v-shex-msft]

HI @Victormar,

I think ISFILTERED and HASONEVALUE functions should more suitable for your requirement, you can try to use the following measure formula if helps:

formula =
IF (
    ISFILTERED ( DIM_Chassis[FLEET_FLEET_ID] )
        || ISFILTERED ( DIM_Chassis[CONTRACT_CUSTOMER_NAME] ),
    IF (
        HASONEVALUE ( DIM_Chassis[FLEET_FLEET_ID] ),
        MAX ( DIM_Chassis[FLEET_FLEET_ID] )
    )
)

Regards,

Xiaoxin Sheng

[Victormar]

The problem is that this one would only return the max, and I would like to return a specific position of a fleet. Say the Customer has two fleets, I would like to create different measures for every fleet related to the customer, so perhaps the first measure would return the first fleet, the second the 2nd... and so on...

The tricky part is how to tell the measure which position of the fleet to return, if that makes sense? Maybe with a rank or an index?