Forum Discussion

Chief's avatar
Chief
Helper II
1 year ago
Solved

summing time utilization

I have the following formula that is calculating the number of days an asset is available during a given month:   Days avail = VAR fleetstart = COALESCE(MIN(RentalTable[FleetDate]), MIN(RentalTa...
Need Help
  • Tutu_in_YYC's avatar
    Tutu_in_YYC
    1 year ago

    This is quick and dirty.

     

    Measure =
    IF( 
        ISINSCOPE(RentalTable[Stock#]),
        [DaysAvail],
        SUMX(
        ALLSELECTED('RentalTable'[Stock#]),
        [DaysAvail]
        )
    )

     


     

    I'd recommend creating star schema for better scalable DAX.

Tutu_in_YYC's avatar
Tutu_in_YYC
Super User
1 year ago

This is quick and dirty.

 

Measure =
IF( 
    ISINSCOPE(RentalTable[Stock#]),
    [DaysAvail],
    SUMX(
    ALLSELECTED('RentalTable'[Stock#]),
    [DaysAvail]
    )
)

 


 

I'd recommend creating star schema for better scalable DAX.

Chief's avatar
Chief
Helper II
1 year ago

Gold Star Tutu!!! This works.