Using CONTEXT() in SELECT()

[Suvrutt_Gurjar]

Maybe it is already a known feature. I was definitely not aware of it.

A few days ago realized that one can use CONTEXT() in SELECT() function’s argument.

For example, the view’s display name below in the header is computed with the below expression using CONTEXT() view. It displays the total order value of all four customers.

CONCATENATE( "Total $ ",SUM(SELECT(Orders[Order Total], OR(CONTEXT(“View”)=“Dashboard”,CONTEXT(“View”)=“All Orders”))))

The use cases seem to be very limited. Could think of only summary views having multiple records and there too the use seems to be limited.

Just sharing for any more ideas/insights/ use cases other colleagues may have.

[diogolupcosta]

wonderful. Didnt know that. Thanks