Hi everybody,
with the following formula I calcute the standard deviation of K values from the begining of record until last week of the current week:
K STDEV Ref = CALCULATE([K STDEV],U_RESULT[DATE_TIME]<(TODAY()-WEEKDAY(TODAY(),2)+1))
In my repors I have a visaul table (Table A) which is filtered in the scope of visual filter to show the K s of the current week.
I need a new column in Table A to show the following measure:
K_Change=K value/[K STDEV Ref]
As I drag [K_Change] to Table A as a new column, the existing DAX filter in measure [K STDEV Ref] i.e "U_RESULT[DATE_TIME]<(TODAY()-WEEKDAY(TODAY(),2)+1)" overrides the "in this week" filter which has been applied on Table A which results to have larger table showing the unfiltered K values.
My question:
Is it possible to add the measure [K STDEV Ref] as a new column in Table A without it being affected from the DAX Filter.
Thanks and Regards, Madhas
