Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
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" ) )
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!
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.
It is not possible for me to use a custom column since the tagging must be done through the measure.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |