Forum Discussion

Emranit's avatar
Emranit
Helper II
1 year ago

Need one value from same multiple value for every machine under every date

A DAX need where i will select one date from queue time and select one Machine no from machine. Then MC loading capacity show same multiple value. Here I need one value instead of same multiple value...
Need Help
m_dekorte's avatar
m_dekorte
Resident Rockstar
1 year ago

Hi Emranit,

You can try something like this:

MC loading capacity once Daily = 
VAR __T =
    FILTER( 
        ALLSELECTED('YourTable'),
        'YourTable'[Machine] IN VALUES( 'YourTable'[Machine] ) &&
        /* Make sure 'YourTable' has a Date column with date values */
        'YourTable'[Date] IN VALUES( 'YourTable'[Date] )
    )
VAR __First = MINX( __T, 'YourTable'[Queue Time] )
RETURN

IF( 
    MAX( 'YourTable'[Queue Time] ) = __First,
    SUM('YourTable'[MC Loading Capacity] ),
    0
)