ALL function within Count in PowerBi

[titanic123]

 Hello everyone,  'ALL' function is not working when using the Count as below:

=CALCULATE(COUNT('WorkTickets'[Ticket Number]),ALL('WorkTickets'[ Status]))

I am using page filter 'Satus' as well. I tried different ways, Please advise.

countx(FILTER('WorkTickets',ALL(WorkTickets[Status])),WorkTickets[Ticket Number])

[PhilipTreacy]

Hi @titanic123 

Download sample PBIX with the following data and code

You didn't initially say what your page filter for Status was doing, or how many status types you have.  Always best to supply some sample data so we can better understand.

With this measure

Count All Tickets = CALCULATE(COUNTROWS('Work Tickets'),ALL('Work Tickets'[Status]))

and this sample data, I don't have an issue

Please supply your data and/or PBIX file so I can check further.

Regards

Phil

[v-yalanwu-msft · Accepted solution]

Hi, @titanic123 ;

I make a simple data then test it , it works fine . so is your data affected by other tables or data?

1.original table.

2.count it .

count = CALCULATE(COUNT('Table'[Ticket Number]),ALL('Table'[Status]))

The final output is shown below:

The '3' is a correct result, if not work, then is show '2'.

so can you share me a simple data which can help understand the specific reasons and further discussion?

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[titanic123]

Hi Phil, As I explained I have page filter for Status ='Active' and I am trying to get all status tickets count in the measure.

[PhilipTreacy]

Hi @titanic123 

How is it not working?  Can you please be specific about what you are trying to do and what you expect as a result.

Please supply sample data too.

Regards

Phil