Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Pass Filtered Table to Calculate Function

I have a trending table and here is a sample data      Date                         Key                   1/27/2019                     1                        1/27/2019                     2   ...
Need Help
  • AlB's avatar
    AlB
    6 years ago

    Hi Anonymous 

    If there's only one key with count > 1 for the last date, you can create a measure and place it in a card visual:

    Measure =
CALCULATE (
    DISTINCT ( Table1[Key] ),
    FILTER (
        Table1,
        CALCULATE ( COUNT ( Table1[Key] ) ) > 1 && Table1[Date] = MAX ( Table1[Date] )
    )
)

    Please mark the question solved when done and consider giving kudos if posts are helpful.

    Cheers  Datanaut

AlB's avatar
AlB
Community Champion
6 years ago

Hi Anonymous 

If there's only one key with count > 1 for the last date, you can create a measure and place it in a card visual:

Measure =
CALCULATE (
    DISTINCT ( Table1[Key] ),
    FILTER (
        Table1,
        CALCULATE ( COUNT ( Table1[Key] ) ) > 1 && Table1[Date] = MAX ( Table1[Date] )
    )
)

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers  Datanaut