
I'm trying to build a report that provides subtotals by the unique values in one or more columns. I'm using PowerBI and Direct query to my Dataverse table.
The report works well with grand totals, but I can't figure out how to get it to provide subtotals. I've played a bit with using GroupBy instead of Summarize, but I'm not getting something correct.
Can someone please provide a good example on how to modify a DAX and change the Summarize to GroupBy correctly?