Forum Discussion
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...
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.
Try:
SUMX(
ALLSELECTED('Table'[Stock#]),
[Days Avail]
)
Tutu - this link is my rental table. I tried your suggestion but the calculation totals all lines, not just the total. Maybe seeing the visual will help understand my desired outcome. When one of the assets is filtered, everything works fine. When the filter is removed, the DaysonRent calcuate a total like they should, the daysavail don't total. Any help is appreciated:
https://drive.google.com/file/d/1e3TdNDOW7pmDy6t90QfAzqRP3SX12hIA/view?usp=sharing
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.
Gold Star Tutu!!! This works.
