Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

2 Filters

I have to Filter a value with the Date and also with the Project names. 
When using the Calculate(value,Allexcept(table,table(date)) function everything works for the date only 
Also the same when using Calculate(value,allexcept(table,table(ProjectName)) then everything works fine for each projectname

How do I combine both filters in 1, so I have different values for each month and each Projectname?

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous ,

    Can only appear once per month and per project? How many months do you have as well as projects? Could you 

     please provide more details with the desired output and pbix file without privacy information.

     

    Best Regards

    Community Support Team _ Polly

     

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

  • mangaus1111's avatar
    mangaus1111
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Hi Anonymous ,

     

    you can try ALL(), instead of allexcept(table,table(ProjectName))

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      So I've got information from lets say 2020 till today. The Information for each Project is weekly.
      For example:
      Project 1: 01.01.2020: Good, 08.01.2020: Okay, 15.01.2020: Good, 22.01.2020: Bad, 29.01.2020: Good (70%)
      Project 2: 01.01.2020: Bad, 08.01.2020: Okay, 15.01.2020: Good, 22.01.2020: Bad, 29.01.2020: Bad (30%)
      Project 3: 01.01.2020: Blank, 08.01.2020: Okay, 15.01.2020: Blank, 22.01.2020: Good, 29.01.2020: Good (100%)

      and so on for each and every project.

      Now I have to create a KPI (List) with the 5 best performing projects, which changes with the date we select through a Timeslicer.

      Some projects have only 10 values for the whole year and some of them have more. 
      Is there a way to sum all and divide it automatically by the amount of projects that are available?
      Or any method to filter for date and project name at the same time so I get different values for each Week or Month and each project