Forum Discussion
Help with filter and measures
Hello Community, I'm new in the PBI and need some help from the start. For example I have this table: Name Food Date Raul Bread 01/06/2020 Raul Bread 01/06/2020 Raul Bread 01/0...
Anonymous
for me it works. check my attached pbix
Hi Anonymous ,
Create a measures
Count Food = CALCULATE(COUNT('Table'[Food]),ALLEXCEPT('Table','Table'[Date]))
CountName = COUNT('Table'[Name])
Regards,
Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
Hello Anonymous ,
Thanks for the answer.
It worked, but after input more data It doesn't work when I filter the data.
The Data:
| Name | Food | Date |
| Beto | Bread | 09/07/2020 09:20 |
| Raul | Bread | 20/07/2020 09:20 |
| Raul | Bread | 14/07/2020 09:20 |
| Raul | Bread | 13/07/2020 09:20 |
| Raul | Bread | 06/07/2020 09:20 |
| Raul | Bread | 21/06/2020 09:20 |
| Raul | Bread | 30/07/2020 09:20 |
| Raul | Bread | 29/07/2020 09:20 |
| Raul | Bread | 28/07/2020 09:20 |
| Raul | Bread | 27/07/2020 09:20 |
| Raul | Bread | 22/07/2020 09:20 |
| Raul | Bread | 21/07/2020 09:20 |
| Raul | Bread | 15/07/2020 09:20 |
| Raul | Bread | 23/06/2020 09:20 |
| João | Bread | 03/07/2020 09:20 |
| João | Bread | 02/07/2020 12:20 |
| Rogerio | Bread | 25/06/2020 09:20 |
| Rogerio | Bread | 24/06/2020 09:20 |
| Rogerio | Bread | 13/07/2020 09:20 |
| Rogerio | Bread | 09/07/2020 09:20 |
| Rogerio | Bread | 30/06/2020 11:20 |
| Rogerio | Bread | 23/07/2020 09:20 |
| Rogerio | Bread | 16/07/2020 09:20 |
| Rogerio | Bread | 22/07/2020 07:20 |
| João | Bread | 03/07/2020 09:20 |
- az38
Community Champion
Hi Anonymous
1. create a calendar table like
CalendarTable = CALENDAR(DATE(2020,1,1),DATE(2020,12,31))2. create relationship between calendar table and Planilha1 table by date field
3. Add CalendarTable[Date] to date slicer visual
4. create a measure in Planilha1 table
Count Food = VAR MaxDate = CALCULATE(MAX(CalendarTable[Date])) VAR MinDate = CALCULATE(MIN(CalendarTable[Date])) RETURN CALCULATE(COUNTROWS(Planilha1), FILTER(ALL(Planilha1), Planilha1[Date] >= MinDate && Planilha1[Date] <= MaxDate))