Showing results for 
Search instead for 
Did you mean: 

Extend delegation to Sum and CountRows

Please extend delegation of Sum and CountRows for the basic datasources:

  • CDS
  • SQL Server
  • SharePoint

Many thanks.


Status: Planned
Level: Powered On

Delegation for countrows would be extremely useful. Is this planned for 2019 for CDS and/or SQL Server?

Level: Powered On

So this feature request is 2.5 years old...


Having the inability to do the equivalent of a "select count" SQL query is super frustrating.  At this point, I'm considering adding a "is_one" column to my tables where every row has an int value of 1, so I can use Sum() to count the rows, assuming I could still use delegation when nesting a Filter insde the Sum.


Any updates form Microsoft on this?