Forum Discussion
Counting Not Occuring
Good morning, sorry a simple question:
I have a table, where I want the count of rows to show on the Y-Axis - but this is not happening. I am using field Statuses which is a Text type.
The fields for both X-axis (MonthYear) and Y-Axis are within the same table.
Kindly advise. Regards
I've deleted all the slicers from the page, now the aggregation is coming through ๐
6 Replies
- BhavinVyas3003Super User
- Drag MonthYear to the X-axis.
- Drag Statuses to the Y-axis.
- In the Visualizations pane, click the dropdown on Statuses and select "Count".
- pankajnamekar25Super User
Hello F_Reh
Go to your visual (e.g., bar chart).
Drag MonthYear to the X-axis.
Drag Statuses to the Y-axis but then change the aggregation
the Visualizations pane, under Values, click on the drop-down next to Statuses.
Thanks,
Pankaj Namekar | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
- F_RehPost Patron
That's what my screenshot is showing that I have done.
- JamesLee94Helper I
To count items that donโt occur in another table in Power BI, use a measure that identifies rows in one table without matching related rows in the other. This typically involves checking which keys from the main table are missing in the related table. Make sure your data model has the correct relationships set up between tables - this is crucial for accurate results. For example, if you want to find products with no sales, the measure will count products whose IDs donโt appear in the sales table. You can also handle cases where related values are blank or missing using conditional logic in your DAX formulas. This approach helps track gaps like unsold products, customers without orders, or missing events in your data.
- F_RehPost Patron
My query is simply that no aggregation occurring when I plainly copied over a field (which is called Statuses) :
- F_RehPost Patron
I've deleted all the slicers from the page, now the aggregation is coming through ๐