Forum Discussion
Filtered value doubles values
Himanshi0291 you have given or condition, if there are 3 rows of same project name with 3 options, it will sum up all three. it is doing as expected, what you want to achieve? Don't want to sum if the project as all 3 values?
Hi, I want that it should sum up all three if it has all three project names.
But in my case I have noticed since all the three project names have a word "Administration" common in them it is summing it multiple times.
For example, let suppose I want the sum of project named= "Administration" so instead of given me the result 1, it gives me 3 means it is picking the value from rest 2 also as they also have "Administration" in project name, which should not happen. How to fix this, please suggest.
Hi , Himanshi0291
The problem is that if there are hours in 'Administration' and no hours in CH administation or Administation HK even then my query adds hours of Administration twice or thrice. Looks like it is adding administration wherever it finds values. CH or HK administration both have 'Administration' word.
I’m not sure what you mean by this word . Filter 1 （project named= "Administration" ）, Filter2 (project named=Administration HK) and Filter3 (CH Administration) are independent of each other, and there is no case of repeated counting.
Can you share some sample data with actual result in pbix and expected result in excel ?
Best Regards,
Community Support Team _ Eason
