Forum Discussion

ThomasJB2004's avatar
ThomasJB2004
Regular Visitor
2 years ago
Solved

Filtering out all False values from my Table

I need to sort the date according to unique numbers (sort of ID), when the ID is detected twice i need the ID with the newest date attached to it. i fixed this with a DAX now the newest date will always be true and the older ones will get set to False.

 

I want to filter out all the False values, this way the other person looking over it can search for it way easier. is there anyway to filter onlt value true? with a slicer it won't work and i tried CountX but i maybe put the formula wrong

 

Thanks in advance!

 

-Thomas

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi ThomasJB2004 ,

    You can follow the steps below to get it, please find the details in the attachment.

    1. Create a calculated column to judge if it is the row with max date per ID

    Flag = 
VAR _maxdate =
    CALCULATE (
        MAX ( 'Table'[Date] ),
        FILTER ( 'Table', 'Table'[id] = EARLIER ( 'Table'[ID] ) )
    )
RETURN
    IF ( 'Table'[Date] = _maxdate, TRUE(),  FALSE() )

    2. Create a slicer to filter the data

    Best Regards

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi ThomasJB2004 ,

    You can follow the steps below to get it, please find the details in the attachment.

    1. Create a calculated column to judge if it is the row with max date per ID

    Flag = 
VAR _maxdate =
    CALCULATE (
        MAX ( 'Table'[Date] ),
        FILTER ( 'Table', 'Table'[id] = EARLIER ( 'Table'[ID] ) )
    )
RETURN
    IF ( 'Table'[Date] = _maxdate, TRUE(),  FALSE() )

    2. Create a slicer to filter the data

    Best Regards

    • ThomasJB2004's avatar
      ThomasJB2004
      Regular Visitor
      2 years ago

      Thanks, Works for me - could even delete my other DAX and still worked