2 Filters

[Anonymous]

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?

[mangaus1111]

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]

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

[Anonymous]

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.