Forum Discussion
Chief
Helper II
Helper IIsumming 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.
Tutu_in_YYC
Super User
Super UserTry:
SUMX(
ALLSELECTED('Table'[Stock#]),
[Days Avail]
)
ChiefHelper II
Helper IITutu - 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
- Tutu_in_YYC
- Tutu_in_YYC
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
Gold Star Tutu!!! This works.