Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Solved! Go to Solution.
@Anonymous
Try a workaround with a measure to show TOP N in your data. Check more details in the attached pbix.
Measure = IF(CONTAINS(TOPN(2,ALLSELECTED('Table'),'Table'[val],ASC),'Table'[id],MAX('Table'[id])),MAX('Table'[id]),BLANK())
Why both topn and rankx are not supported in my version? I got the same error.