¿How to block the filter in count?

[#1]

Hi there,

I need make a Count() with the variable filter and no variable filter.

I mean, i need count the tickets by week and divide by the total tickets. The follow formule shows the count:

(Count({$<[Task Status]={'closed'},[Task Type]={'CM'}>}[Task ID])>}[Task ID]))/Count([Site ID*])

The problem is in the red part, because i need count the total "Site ID" and not the count "Site ID*" by week.

Best regards

[Gysbert_Wassenaar]

Perhaps Count(TOTAL [Site ID*])

[sunny_talwar]

Is there a sample you can share with the expected output?

[#4]

No, this is a current formule.

[rudolfhbantim · Accepted solution]

if do you want count side id not considering the dimension, you can use Count(TOTAL Distinct [Site ID*]), but if you want not consider any selections, Count({1}TOTAL Distinct [Site ID*]).

[#6]

You can create a variable for total count and then you can use it divide.

Variable:

vTotalCount=Count([Site ID])

Then your final formule will be like below:

=(Count({$<[Task Status]={'closed'},[Task Type]={'CM'}>}[Task ID])>}[Task ID]))/vTotalCount

[tyagishaila]

It may be,

Count(Total [Site ID])

I hope You have already tried it. After that did you got your required result or not?

If yes than please close the thread to choose correct answer, and if no than share sample data, to know actual issue.

Cheers.