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.
wonderful. Didnt know that. Thanks
User | Count |
---|---|
37 | |
30 | |
29 | |
20 | |
18 |