Forum Discussion
kirah2128
Resolver I
Resolver IFilter Context Calculations
Dear All, I'm still learning the DAX language. And I'm having a hard time. I have a scenario where I need to get the correct COMPONENT HOURS. The result I want is in the Car Filter Context b...
Hello, i'm sorry but your explanation is not clear. I understand that the total is wrong is your table but that you calculated it yourself in the source.
Can you show us the measure if you have one, the total given by Power BI in the bottom of your table and the model with the relationships if there is more than one table involved ?
If in power bi, you put the SUM of component hours without axes, it shows you the correct answer ? if yes, the result shouldn't change when you add axes. if no, the problem is maybe in power query or in the query you use in your source.
kirah2128Resolver I
Resolver I
CARS USAGE = SUM('CARS UTILIZATION'[cars_utilziation_in_mins])/60
QTY PER CAR = COALESCE(MAX('QTY COMP PER CAR'[qpa]),0)
COMPONENT HRS = [CARS USAGE] * [QTY PER CAR]