Forum Discussion
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...
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))
[Measure] =
COUNTX(
FactTable,
var __value =
// This division, since it's performed
// on an individual row level, should be
// stored in a column in the fact table.
// This value would then only be retrieved
// from the column instead of calculated.
// This way the measure would be much faster.
DIVIDE(
// If something is qualified with the name
// of a table, it's a column. If it's not
// qualified, it's a measure. This is the
// convention in DAX that every DAX dev
// follows.
FactTable[Month of Engagement],
FactTable[Months In Contract L30],
0
)
var __test =
and(
0.75 <= __value,
__value <= 1.00
)
return
DIVIDE( __test, __test )
)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))