Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Top N and EARLIEST function in power bi

Hello,
AVG= CALCULATE( AVERAGE(FCCU[AVG]) ,FILTER(FCCU,FCCU[TS] = EARLIEST( FCCU [TS]) && TOPN(1,FCCU)))
I am trying for this give me error for earlist function .I want output as earlist record of TS top 2 records and there average .
want to show them in a table

 

 

way ealiest function not working.....

 

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

     

    hello,
    can I do this in mesure..top 3 value and earliest ts (date) becouse i want to show that in a table so if i am directly filter that directly it will impact on hole table so i want to write measure.

    regards
    Pooja

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      HI Anonymous,

       

      Nope, topn filter not works for measure and earliest function only works in calculate column/table.

      In my opinion, I'd like to suggest you use rankx function to write a measure to get rank value, then use it in visual level filter to achieve similar topn filter effect.(is less than or equal to 3)

       

      Reards,

      Xiaoxin Sheng