Forum Discussion

diyannavarro's avatar
diyannavarro
Frequent Visitor
6 years ago

DAX Slicer for Measure Values

Hi,

I have created a conditional dax measure to tag each account with "Current" and "Past Due".

 

Here is the Dax Measure:
"IF( (TermLessSix && LTDateFilter && PDIndicator && GLGZero) || ( TermPlusSix && PDIndicator && DateFilterCuring && GLGZero && LRDateFilter), "PAST DUE",
IF( PDate && ZeroGL, "PAID",
IF( ZeroGL && MTDateFilter, "NOT YET RELEASED",
"CURRENT"
)))"
 
Now I want to create a slicer to filter the data to 'Current' and 'Past Due' but I don't know how. Can anyone help me?
 
Thanks!
DAX
Measures
Slicer

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Not sure, if you could have created this a New Column, instead of measure. 

    Second, you can put that into a Matrix and it should allow filter when you click on the value. 

     

    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.