atoti.Measure.isin()

@overload
Measure.isin(
*values: Constant,
) → MembershipCondition[MeasureIdentifier, ‘IN’, Constant] | RelationalCondition[MeasureIdentifier, ‘EQ’, Constant]

@overload
Measure.isin(
*values: Constant | None,
) → MembershipCondition[MeasureIdentifier, ‘IN’, Constant | None] | RelationalCondition[MeasureIdentifier, ‘EQ’, Constant | None]

Return a condition evaluating to True where this measure evaluates to one of the given values, and evaluating to False elsewhere.

Parameters

*values

One or more values that the measure will be compared against.

>>> df = pd.DataFrame(
...     columns=["City", "Price"],
...     data=[
...         ("Berlin", 150),
...         ("London", 270),
...         ("Madrid", 200),
...     ],
... )
>>> table = session.read_pandas(df, keys={"City"}, table_name="Example")
>>> cube = session.create_cube(table)
>>> m = cube.measures
>>> m["Price.SUM"].isin(150, 270)
m['Price.SUM'].isin(150, 270)

Conditions on single values are normalized to equality conditions:

>>> m["Price.SUM"].isin(150)
m['Price.SUM'] == 150

Measure.formatter

Measure.isnull()

⌘I

Releases and upgrades

Getting started

Guides

API reference

Measure.isin()

Parameters

*values

​Parameters

​*values

Parameters

*values