Forum Discussion

dana1's avatar
dana1
Frequent Visitor
8 years ago
Solved

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.

  • 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,

2 Replies

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee

    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's avatar
      parry2k
      Super User

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