Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Displaying data by latest timestamp

Hi there,   I am building a report to visualize number of patients on each hospital unit. This data is inputted by nursing staff throughout same day. The idea is to create a table that shows last i...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi Anonymous ,

     

    You can create a visual level filter:

     

    Measure = IF(MAX('Table'[Created]) = CALCULATE(MAX('Table'[Created]),ALLEXCEPT('Table','Table'[Unit])),1,0)

     

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

parry2k's avatar
parry2k
Super User
5 years ago

Anonymous add following measure to get the result:

 

Measure = 
CALCULATE ( 
    SUM ( 'Table (2)'[Number of Patients] ), 
    KEEPFILTERS (
        TOPN ( 1, ALLSELECTED ( 'Table (2)'[Created] ), CALCULATE ( MAX ( 'Table (2)'[Created] ) ), DESC ) 
    ) 
)

 

 

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡