Grouping Data Table Reports

Question

Hello Everyone!&nbsp;Fairly new user but I have been constantly doing research to improve my understanding of this wonderful application!&nbsp;Am running into a few issues I hope I can get help with, but its important to first note I do not have access to Power Query Editor, only DAX measures and other desktop features. I have been creating basic table reports for now, but require reports to be created in the format below. I cannot figure out if I need to change to a Matrix style report, if I can group this data using DAX, or some other feature (again I cannot use Power Query so cannot use the GROUPBY feature)&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Houses&nbsp; &nbsp; &nbsp; &nbsp;State&nbsp; &nbsp; &nbsp; &nbsp;Total House Value&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NY&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$126,500,000Count&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 120&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FL&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $110,000,000Count&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;Total Count&nbsp; 220&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $236,500,000&nbsp;&nbsp;Thank you for taking the time to look into this!&nbsp;

danextian · Answer

Hi DataQueen ,
&nbsp;
First, I am curious why you are not able to use the query&nbsp; editor. Second, please post a sample data (not an image). And third, can you please post your sample result as an image with the gridlines and all. This can help us visualize what you're trying to achieve or if it is even doable.

Forum Discussion

Grouping Data Table Reports

1 Reply

Related content

Fabric & Azure Data User Group Program Requirements & Benefits

Community User Group Experience

Table with dynamic grouping of rows

Filtering Table report

User Group Leader Get Started Guide