Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.....
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
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |