© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022
A. BoxUp and Running with DAX for Power BI https://doi.org/10.1007/978-1-4842-8188-8_19

19. The CALCULATETABLE Function

Alison Box1  
(1)
Billingshurst, West Sussex, UK
 

Now that you are officially a DAX expert, you are ready to confront DAX expressions that will truly test your knowledge and understanding of DAX. One of the DAX functions that can only be understood with a clear grasp of how DAX works is CALCULATETABLE, and this rather obscure function is the last function we will investigate in this book.

CALCULATETABLE operates in all the same ways as CALCULATE except that it returns a table rather than a scalar value. In other words, it returns a table or ...

Get Up and Running with DAX for Power BI: A Concise Guide for Non-Technical Users now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.