Forum Discussion

F_Reh's avatar
F_Reh
Post Patron
1 year ago
Solved

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

    • Drag MonthYear to the X-axis.
    • Drag Statuses to the Y-axis.
    • In the Visualizations pane, click the dropdown on Statuses and select "Count".
  • 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.

  • F_Reh's avatar
    F_Reh
    Post Patron

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

  • 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's avatar
    F_Reh
    Post Patron

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

     

  • F_Reh's avatar
    F_Reh
    Post Patron

    I've deleted all the slicers from the page, now the aggregation is coming through ๐Ÿ™‚