Counting Not Occuring

[F_Reh]

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

[F_Reh · Accepted solution]

I've deleted all the slicers from the page, now the aggregation is coming through 🙂

[F_Reh]

My query is simply that no aggregation occurring when I plainly copied over a field (which is called Statuses) :

[JamesLee94]

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_Reh]

That's what my screenshot is showing that I have done.

[pankajnamekar25]

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 | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

[BhavinVyas3003]

• Drag MonthYear to the X-axis.
• Drag Statuses to the Y-axis.
• In the Visualizations pane, click the dropdown on Statuses and select "Count".