Forum Discussion
ALLEXCEPT FUNCTION HELP!
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.
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,
2 Replies
- v-sihou-msftMicrosoft Employee
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,