Creating a Slicer to a Measure

[Peejz_Jalmasco]

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!

[v-juanli-msft]

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]

@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!

[amitchandak]

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.

[Peejz_Jalmasco]

@amitchandak 

It is not possible for me to use a custom column since the tagging must be done through the measure.

[Ashish_Mathur]

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.