Forum Discussion
Relationship issue with Measure
Hi Experts I have been looking at this problem for 3 days and cannot see why my table to the right does not show the same p-value for each of the month periods. Scenario If you select product id ...
New Table
My Table = VAR OuterComplaints = COUNTROWS ( PMS_COMPLAINT ) RETURN ADDCOLUMNS ( VALUES ( PMS_FINANCIAL_PDS[Month Start] ), "CountComplaints", CALCULATE ( COUNTROWS ( PMS_COMPLAINT ) ), "Index", RANKX ( PMS_FINANCIAL_PDS, PMS_FINANCIAL_PDS[Month Start],,, DENSE ), "Outer Complaints", OuterComplaints )Something along these lines...
Haven't been able to look at this a whole lot the past couple of days. The problem of a wrong value in a total is generally the result of evaluating a measure with no filters. The fix is either to do a SUMX of the measure over the distinct months, or to have an IF statement that evaluates the measure differently if there are no filters.
Another expert also tried
I've just tried to see what values EARLIER formula returns, and it seems like it returns the same value as if there were no EARLIER function.
I created the measure below to check the output:
__testS =
VAR Mytable1 = ADDCOLUMNS(VALUES(PMS_FINANCIAL_PDS[Month Start]);"CountComplaints";CALCULATE(COUNTROWS(PMS_COMPLAINT));"Index";RANKX(PMS_FINANCIAL_PDS;PMS_FINANCIAL_PDS[Month Start];;;Dense))
VAR cc =
SUMX(Mytable1;
SUMX(Mytable1;
EARLIER([CountComplaints])
)
)
VAR i =
SUMX(Mytable1;
SUMX(Mytable1;
EARLIER([Index])
)
)
RETURN
i & ", " & cc