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 ...
Need Help
mangaus1111's avatar
mangaus1111
Solution 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