Forum Discussion

ipezakas's avatar
ipezakas
Helper I
1 year ago
Solved

Measure doesnt work as expected inside VAR

Hello community!  I have the following issue:  I have created a visual table with project_id and time to market column. i have created 2 measure that calculate the topthreshold/bottomthreshold  f...
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    1 year ago

    ipezakas Create the measures for thresholds:

    DAX
    TopThreshold =
    PERCENTILEX.INC(
    FILTER(ALLSELECTED(Projects), Projects[TIME_TO_MARKET_(TtM)] >= 0),
    Projects[TIME_TO_MARKET_(TtM)],
    1 - [Percentile] / 100
    )

    BottomThreshold =
    PERCENTILEX.INC(
    FILTER(ALLSELECTED(Projects), Projects[TIME_TO_MARKET_(TtM)] >= 0),
    Projects[TIME_TO_MARKET_(TtM)],
    [Percentile] / 100
    )

     

    Create a measure for the outlier flag:

    DAX
    (TtM) Outlier Flag Measure =
    VAR CurrentTtM = SELECTEDVALUE(Projects[TIME_TO_MARKET_(TtM)])
    VAR BottomThreshold = [BottomThreshold]
    VAR TopThreshold = [TopThreshold]
    RETURN
    IF(
    NOT ISBLANK(CurrentTtM) &&
    (CurrentTtM < BottomThreshold || CurrentTtM > TopThreshold),
    1,
    0
    )

     

    Add the (TtM) Outlier Flag Measure to your visual table. This measure will dynamically calculate the flag based on the current filter context applied to the visual.

     

bhanu_gautam's avatar
bhanu_gautam
Super User
1 year ago

ipezakas Create the measures for thresholds:

DAX
TopThreshold =
PERCENTILEX.INC(
FILTER(ALLSELECTED(Projects), Projects[TIME_TO_MARKET_(TtM)] >= 0),
Projects[TIME_TO_MARKET_(TtM)],
1 - [Percentile] / 100
)

BottomThreshold =
PERCENTILEX.INC(
FILTER(ALLSELECTED(Projects), Projects[TIME_TO_MARKET_(TtM)] >= 0),
Projects[TIME_TO_MARKET_(TtM)],
[Percentile] / 100
)

 

Create a measure for the outlier flag:

DAX
(TtM) Outlier Flag Measure =
VAR CurrentTtM = SELECTEDVALUE(Projects[TIME_TO_MARKET_(TtM)])
VAR BottomThreshold = [BottomThreshold]
VAR TopThreshold = [TopThreshold]
RETURN
IF(
NOT ISBLANK(CurrentTtM) &&
(CurrentTtM < BottomThreshold || CurrentTtM > TopThreshold),
1,
0
)

 

Add the (TtM) Outlier Flag Measure to your visual table. This measure will dynamically calculate the flag based on the current filter context applied to the visual.

 

ipezakas's avatar
ipezakas
Helper I
1 year ago

Is it possible to make this work as a calculated column as well? Cause when i am trying to use it as filter inside a column chart the visuals breaks.