Forum Discussion
SelectedValue Question
Hi there.
As you said, i'm trying to get a result from the previus week using the currently week as parameter. The thing is that when the currently week has no value (I dont have any lines with any values, of course, the result for the sum is 0 and also, the parameter that i'm looking is blank) which means that as the measure is looking for the parameter - 1. As the parameter is 0 or blank the result is Measure, filter by something where the result is -1.
Example:
CALCULATE([MEASURE], Number Week = Week - 1 (As the week is blank or 0, the result will always be -1).The way the I found to solve it right now is create another table with all the posibles weeks and also create a Primary Key with Week&Market (is this case market is COSA, LATAM and ROW). And with that I will always have a week number and the measure will work just fine.
But, I dont know if this is the best way. Unfortunetly was the way that i found to fix the problem that i had.
Regards,
Hi,
I am not sure how your datamodel and measure looks like, but I assume COSA, LATAM, and ROW have more than one value in the filter context that is shown on the report page.
Please check the link down below how SELECTEDVALUE DAX function returns.
SELECTEDVALUE function - DAX | Microsoft Learn
-> The value when the context for columnName has been filtered down to one distinct value only. Else, alternateResult or BLANK.
Try using MAX or MIN DAX function and check whether it suits your requirement.
I hope this helps.
yes!
The example that i gave before is just the beginnig of what i'm woking on.With the measure Selectedvalue -1 i have one more measure with calculate that is Calculate(sum(XXX), week num = Selectedvalue - 1.
The problem is as the selectedvalue -1 is blank or -1 and is not 43 as it should be i cant get the right result.
Regards,