Forum Discussion

AbhishekPandey's avatar
AbhishekPandey
Icon for Helper I rankHelper I
5 years ago
Solved

Need Correct Total

I have a measure in which i am dividing total number of contractual months from total number of months. I am getting correct result, but the total in the bottom is not correct.   The first column i...
  • AbhishekPandey's avatar
    AbhishekPandey
    5 years ago

    Anonymous Thanks for the suggestion i got the fix, this time not using the variable anywhere in the expression.
    This i have added in the else part of hasonevalue.
    SUMX(
    FILTER(
    VALUES('Table'[id]),divide(Month of engagement, Months in Contract L30)>=0.75 && divide(Month of engagement, Months in Contract L30)<=1.00),1))


Anonymous's avatar
Anonymous
Not applicable
5 years ago
What is the structure of your fact table? If you perform a calculation on an individual row level of the fact table, then move the calculation to a column, do not use DAX to do it on the fly, use Power Query or do it in the source. This is the first piece of advice. Secondly, variables in DAX are constant, once they've been defined, they do not change (DAX is a functional language).