Forum Discussion

kirah2128's avatar
kirah2128
Icon for Resolver I rankResolver I
2 years ago

Filter 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...
DAX
powerbi
Anonymous's avatar
Anonymous
Not applicable
2 years ago

You should try a SUMX in your measure. Right now, your measure total is the total of car usage (183196) * total of QTY per usage (2) which is wrong for you. 
You want to do the multiplaction for each row and then sum all the results. 

Try something like SUMX('CARS MODEL', [CARS USAGE]  * [QTY PER CAR])