CurrentTuple

Returns the current tuple in a set. Current is in the context of query execution mechanics. Use in combination with iterative functions such as Filter.

Syntax

CurrentTuple ( set )

set.Current

set.CurrentTuple

Example

The following example finds all Product, Market combinations for which Sales data exists.

WITH SET [NewSet] 
AS 'CrossJoin([Product].Children, [Market].Children)'
SELECT
   Filter([NewSet], NOT IsEmpty([NewSet].CurrentTuple)) 
ON COLUMNS
FROM Sample.Basic
WHERE
   {[Sales]}

This query returns the following grid: