Forum Discussion

madhas's avatar
madhas
Frequent Visitor
3 years ago
Solved

DAX FILTER, VISUAL FILTER Interaction

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
 
Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    madhas , Calculated column do not take any slicer value, They are static in natire