Number of Occurrence within the slicer date

[ashu710]

Hi everyone, I wanted to make a measure that shows the number of occurrences with regard to a date slicer.

For example, if the slicer says "01-01-2022" to "30-01-2022", B=3 and A=3. Thanks for the help.

[v-angzheng-msft · Accepted solution]

Hi, @ashu710 

Try to create a measure:

Measure = CALCULATE(COUNT('Table'[ID]))

Or drag and drop into the value bucket and change the aggregation method to count

Result:

Please refer to the attachment below for details.

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[edhans]

I don't know how that data is A=3 and B=3. From Jan 1 to Jan 3, it is A = 2, B = 1.

To do this:

1. Put the date in a slicer
2. Create a Table Visual, and put the Data column (a, b, etc) in there.
3. Create a measure:
   1. Fact Table Count = COUNTROWS('Table')
      
      
4. It simply counts the rows within the date range.

You can see my PBIX here if you want to play with it. 

If you need more help, please provide more info.

How to get good help fast. Help us help you.

How To Ask A Technical Question If you Really Want An Answer

How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.