Forum Discussion

SHKRV's avatar
SHKRV
Regular Visitor
5 years ago
Solved

Visualizing each distinct row by latest date

Hi,   I have a simple excel table with three processes. There are target dates for these process by which they need to be finalized. Every month I add new rows to the table and update the process. ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    SHKRV , Create a measure like this

    Measure = CALCULATE(COUNT('Table'[process]) ,FILTER(('Table'),'Table'[update Date] =CALCULATE(max('Table'[update Date]),ALLEXCEPT('Table','Table'[process]))))

     

    and use it with all non summarized columns

SHKRV's avatar
SHKRV
Regular Visitor
5 years ago

amitchandak ,

 

Thanks a lot for a quick reply.

 

It works perfect when I add this new measure to the table as a column. But I do not want to see that as a column in my table. Instead I added the measure to Filters section and selected "is not blank". It works fine.

 

Note: the name of my measure is "test"