Forum Discussion

kabra_ashish's avatar
kabra_ashish
Helper III
6 years ago
Solved

Table Visual - Conditional Formatting

I have a table visual with the below fields:   Date             Trans_Id        Spend($) Jan 1              ABC123            100 Jan 2              DEF123            100 Jan 3              GHI1...
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi kabra_ashish ,

     

    Create a measure

    Measure = 
var _maximumcountall = MAXX(SUMMARIZE(ALL('Table'),'Table'[Date],"CC1",COUNT('Table'[Date])),[CC1])
var _maxdate = MAX('Table'[Date])
var _count = COUNTROWS(FILTER(ALL('Table'), 'Table'[Date] = _maxdate))
RETURN
if (_count = _maximumcountall, 1, 0)

     

     

    Regards,
    Harsh Nathani
    Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

kabra_ashish's avatar
kabra_ashish
Helper III
6 years ago

Greg_Deckler After creating this measure and then incorporating to the table visual it still gives 1 for each record