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,

There are some issues with your model and selected fields in Slicers. 
I've replaced your "Date" column, in Power Query with:

Table.AddColumn( #"Changed Type", "Date", each DateTime.Date([QueueTime]), type date)

Important! Used this new "Date" column in the Hierarchy slicer on the left of the page.

 

Created a supporting measure:

First QueueTime = 
    CALCULATE (
        MIN ( September[QueueTime] ),
        ALL( September ),
        VALUES( September[Machine] ),
        VALUES( September[Date] )
    )

 

And this Measure:

MC loading capacity once Daily = 
VAR __T =
    SUMMARIZE( 
        September,
        September[Machine],
        September[Date],
        September[MC Loading Capacity]
    )
RETURN

IF( NOT ISINSCOPE( September[Machine] ),
    SUMX( __T, [MC Loading Capacity] ),
    IF( 
        MIN( September[QueueTime] ) = [First QueueTime],
        SUMX( __T, [MC Loading Capacity] )
    )
)

 

With this result.

 

Emranit's avatar
Emranit
Helper II
1 year ago

Thanks for nice solution. Is it possible for summation of MC loading capacity each day without Date column? Actullay in my source fie(SQL Database) there is no Date Column. MC loading Capacity summation base will be QueTime.

 

Then I need all day MC loading capacity summation.