ALLEXCEPT FUNCTION HELP!

[dana1]

hello,

I really need help with the function ALLEXCEPT (or any solution..)

here is my table-

The table is filtered by a number of Values such as : manager name = dan

I need to add another value to the table, but the value will not be filtered according to the filters I defined, but according to one specific filter.

here is the measure-

CALCULATE([answer percent],ALLEXCEPT(vw_aggregate_IN_calls,vw_aggregate_IN_calls[queue],DIM_date[margedate].[Date]))

answer percenr- is the value that i need to be on the table.

all im getting is the same percernt for each day.

[v-sihou-msft · Accepted solution]

@dana1

In your scenario, if you want to use the value from your [answer percent] as a filter to slice your data, you have to SUMMARIZE that measure into a column. I suggest create a calculated table. 

Regards,

[parry2k]

@dana1 can you share how your [answer percent] measure look like?