Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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.
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:
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.