What would be your solution using a measure? For example, if a column is a date or time data type, Power BI Desktop won't let you choose geographic data categories. After logging in you can close it and return to this page. In the below screenshot you can see the measure are categorized by Type i.e. Returns the smallest numeric value in a column. Power BI - Conditional Sum of Two or More Than Two Categories in Table Data Science Tutorials 48.2K subscribers Subscribe 22 Share Save 6.6K views 1 year ago Complete Power BI Tutorials. Find out more about the February 2023 update. powerbi dax Share Improve this question Follow You then drag fields that contain numeric values into the values area so that they can be counted, averaged, or summed. Method 2: Cumulative Totals without Date columns (order by categories) A quick solution to calculate cumulative totals without a date column is using other existing numeric fields, luckily in this . You just need to know how to use CALCULATE to adjust your filter context. Power BI - DAX for Rolling Sum (Running total) not working, Getting workdays for the year in Power Pivot DAX, DAX SUMMARIZE function isn't respecting row-based security in my Power BI Model. When you have a general idea of how your data should be grouped to be meaningful, and the values that you want to work with, you can decide whether to build a PivotTable or create calculations within a table. var links=w.document.getElementsByTagName("link");for(var i=0;i