Forum Discussion
Solved
Creating a derived table in Power BI
I have a table which when used with extensive DAX, i keep getting the "Cannot display visual "as not enough reources available. When checking the analyzer, there is a DAX that is taking up majority o...
PBI5851 , new table
summarize(Table,Table[AccountDate],Table[Client], Table[AccountStatus], "Count",countrows(Table)))
Also, refer how can work with a table and aggregated Table
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-aggregations
https://radacad.com/power-bi-aggregation-step-1-create-the-aggregated-table
Hi PBI5851
If you connect to sql server with import mode, please enter sql statement as below:
Select SubjectId, ExamDate, count(StudentNo) as CountNum From dbo.Result$ Group By SubjectId, ExamDateThen can limit the rows imported into power bi.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.