Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Interval in Generate series

Hi,

 

I have a problem statement where i want filter on my dataset using a user defined value without using the greater than option in slicer.

I have created parameter using the whatif and then i am referring it into a measure i have created for it with the slicer condition.

The problem i am facing is that the filter in on a value which goes into billions and having set an interval of 100,000 

the value getting entered manually or via slicer doesn't seem to follow the interval set by me.

 

Can someone help with this on how to circumvent this?

Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    5 years ago

    Hi , Anonymous ; 

    From my understanding, you can create a slicer column first, and then use flag measure to filter, as follows:

    First : Create a slicer column

    slicer =
IF (
    [Parameter] <> MAX ( [Parameter] ),
    [Parameter] & "~"
        & CALCULATE (
            MIN ( [Parameter] ),
            FILTER ( ALL ( 'Parameter' ), [Parameter] > EARLIER ( [Parameter] ) )
        ),
    [Parameter] & "+"
)

    Second : Create a flag measure

    flag =
VAR _min =
    MAX ( [Parameter] )
VAR _max =
    CALCULATE (
        MIN ( [Parameter] ),
        FILTER ( ALL ( 'Parameter' ), [Parameter] > MAX ( [Parameter] ) )
    )
RETURN
    IF (
        MAX ( 'Table'[Value] ) < _max
            && MAX ( 'Table'[Value] ) >= _min,
        1,
        IF (
            MAX ( [Parameter] ) = MAXX ( ALL ( 'Parameter' ), [Parameter] )
                && MAX ( 'Table'[Value] ) >= _min,
            1
        )
    )

    Then : Put flag measure into visual filter

    The final output is shown below:  

          

    If I understand incorrectly, please provide me with more details or pbix after removing sensitive data

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.  

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , in place of whatif, simply create a series using generate series and try to use that as a slicer 

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi , Anonymous ; 

    From my understanding, you can create a slicer column first, and then use flag measure to filter, as follows:

    First : Create a slicer column

    slicer =
IF (
    [Parameter] <> MAX ( [Parameter] ),
    [Parameter] & "~"
        & CALCULATE (
            MIN ( [Parameter] ),
            FILTER ( ALL ( 'Parameter' ), [Parameter] > EARLIER ( [Parameter] ) )
        ),
    [Parameter] & "+"
)

    Second : Create a flag measure

    flag =
VAR _min =
    MAX ( [Parameter] )
VAR _max =
    CALCULATE (
        MIN ( [Parameter] ),
        FILTER ( ALL ( 'Parameter' ), [Parameter] > MAX ( [Parameter] ) )
    )
RETURN
    IF (
        MAX ( 'Table'[Value] ) < _max
            && MAX ( 'Table'[Value] ) >= _min,
        1,
        IF (
            MAX ( [Parameter] ) = MAXX ( ALL ( 'Parameter' ), [Parameter] )
                && MAX ( 'Table'[Value] ) >= _min,
            1
        )
    )

    Then : Put flag measure into visual filter

    The final output is shown below:  

          

    If I understand incorrectly, please provide me with more details or pbix after removing sensitive data

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.