Forum Discussion

Peejz_Jalmasco's avatar
Peejz_Jalmasco
Helper I
6 years ago

Creating a Slicer to a Measure

Hi Experts!!

 

I'm a newbie in using DAX, but I need to create a slicer that will filter the values of a Measure. Here is my measure:

Past Due = If([Outstanding Balance] > [Amortization Balance] && [Due Date] < MAX('Calendar'[Date]), "Past Due", "Current")

 

Now when in the report I need to have a slicer to filter those Past Due and Current accounts.

 

Thanks for your help!

Interesting Links
Need Help
Show and Tell
Tips and Tricks

5 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    6 years ago

    Hi,

    I am not sure of how much i can help I'd like to try.  Share the link from where i can download your PBI file.

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    New column like this should work

     

    Past Due = 
var _v1 =MAX('Calendar'[Date])

return If([Outstanding Balance] > [Amortization Balance] && [Due Date] <_v1 , "Past Due", "Current")

    Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
    Thanks.

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    6 years ago

    Hi Peejz_Jalmasco 

    Create a date table without relationship with your tables.

    date = CALENDARAUTO()

     

    Then add date column from this date table to a slicer,

    Create measures

    Measure =
VAR maxseletced =
    CALCULATE ( MAX ( 'date'[Date] ), ALLSELECTED ( 'date' ) )
RETURN
    IF (
        [Outstanding Balance] > [Amortization Balance]
            && MAX ( Sheet9[date] ) < maxseletced,
        "Past Due",
        "Current"
    )

    or 

    Measure 2 =
VAR maxseletced =
    CALCULATE ( MAX ( 'date'[Date] ), ALLSELECTED ( 'date' ) )
RETURN
    IF (
        [Outstanding Balance] > [Amortization Balance],
        IF ( MAX ( Sheet9[date] ) < maxseletced, "Past Due", "Current" )
    )
    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • Peejz_Jalmasco's avatar
      Peejz_Jalmasco
      Helper I
      6 years ago

      v-juanli-msft 

      Hi Maggie,

       

      What I need to slice is the Measure (based on your sample) where the table will only show current or past-due whichever I choose in the slicer.

       

      Thanks!