Forum Discussion

AleMacedo's avatar
AleMacedo
Icon for Helper I rankHelper I
4 years ago
Solved

Allexecpt with multiple filters

Hi all, I have a single table of monthly  produtivity employees reports. I have a measure for media for each task category and need to calculate media for all company in each category with filters ...
Need Help
Tips and Tricks
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    Hi AleMacedo 

    Try code like below,

    Media MPSP =
    calculate(
    [Media],
    Filter(ALLEXCEPT(Rels,Atributos[Atributo],Relatorios[Relatorio],Calendario[Date].[Date],UnidadeAdministrativa[Entrancia]),Rels[date]= min(Calendario[Date])  ))
    Generally speaking, it filters the table Rels based on the date in the current row.
     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

AleMacedo's avatar
AleMacedo
Icon for Helper I rankHelper I
4 years ago

I did it:

Media MPSP =
calculate(
[Media],
ALLEXCEPT(Rels,Atributos[Atributo],Relatorios[Relatorio],Calendario[Date].[Date],UnidadeAdministrativa[Entrancia]))
 
but its not considering filter for date. All the other filters are ok.
v-xiaotang's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
4 years ago

Hi AleMacedo 

Try code like below,

Media MPSP =
calculate(
[Media],
Filter(ALLEXCEPT(Rels,Atributos[Atributo],Relatorios[Relatorio],Calendario[Date].[Date],UnidadeAdministrativa[Entrancia]),Rels[date]= min(Calendario[Date])  ))
Generally speaking, it filters the table Rels based on the date in the current row.
 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

  • AleMacedo's avatar
    AleMacedo
    Icon for Helper I rankHelper I
    4 years ago

    Thank you!!